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 inserting data into a database. When I click the button, I do not get an error but neither do I have the data inserted into my database. I am using Access 2007 and Livecycle ES 8.2. The form information on...

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.

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 have either thought I did, or forgot to do/redo. When I am in the midst of design and testing.Jenn D.

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 is set) DateFmt(2, "fr_CA") returns - YY-MM-DD DateFmt(3, "de_DE") returns - D. MMMM YYYY DateFmt(4, "fr_FR") returns - EEEE D' MMMM YYYY I don't know if you can customize it further or not... Jenn D.

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.

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 info into the db in a sensible manner, I think that it will all work the way we need it too and everyone will be much happier than they are with the current system. Thanx a bunch! Jenn D.

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 appreciate you taking the time to respond to my posts. I hope you have a great weekend!Jenn D.