I know this is an old thread, but if anyone has an example they could send I would be eternally grateful. I have my Access DB connected to my form and it fills in beautifully with the information from the database. So I know that it is connected. I have followed all the tutorials I can find on inser...

Paul, My Email is jdickens@dse.net.I did set the connection to delay and have been trying to find the commands to connect as needed. Thank you so much for the help. Jenn D.

work in engineering... we have a change process that we have to go through to make a change on our product. I have a form - ECR that I can send to an engineer to start the process. I fill in the ECR #, the product name and the date (there are lots of other fields but I want to keep this simple). The...

I assume that you have set up the data connection and that you named this data connection "DataConnection" and bound the fields that you want to see information in. I know these are basic questions, but when I'm frusterated, I sometimes forget the simplest things. These are some simple things that I...

oh! Now how simple is that?!! Thank you!Jenn D.

I assume that you get this from Insert/Custom/Current Date???You need to change the # in the script to match the format you want... According to the Adobe help files...(search DateFmt)The following expressions are examples of using the DateFmt function: DateFmt(1) returns - M/D/YY (if en_US locale i...

I have this problem sometimes when I forget to change the script Language to FormCalc. In my VERY limited experience, I believe xfa.sourceSet.DataConnection.next() is a FormCalc expression... please forgive my ignorance if I am wrong...Jenn D.

I have a field that if it is empty, needs to be filled, but if it has data, I need that data to be left as is...I know how to write the if and have it fill in the info I need, however, what do I put for the else? So far I have var iVar=0;if ((ECR_Nmr.rawValue==null){xfa.sourceSet.ECP_ECR.last()iVar=...

That is what I intend to do. (I do not need it to go into an Access form, just the database so that the information is usable for reporting). I haven't actually done a distribute/submit in Adobe 9 yet so I'm not sure how/if it differs from 8.0. If I can collect the 'submitted' forms and 'export' the...

Not the way I had originally thought I wanted to. I have come up with a creative work-around though. (See previous posts in this discussion). I'm almost to a point that I can start experimenting with how DC can send the engineer's info to the database once they submit it back to her. I really apprec...