Microsoft Access

Re: Submitting an InfoPath 2003 form back to an Access database

Dukane — Fri, 27 Jun 2008 19:19:53 GMT

I have a question kind of along these lines - Does anyone know how you could submit the same form multiple times and have it create a new record in an Access database each time? I'm creating a form that populates an Access database and is e-mailed each time it is submitted, but my team wanted to be able to submit it again after changing only a couple fields. The problem is if the form stays open and they resubmit, it just overwrites the record they just created. I tried making a button that opens a new form and closes the old one (resets it), then another button they can use that queries the database using the primary key, then the form repopulates what they just entered. The problem is the new form is then linked to that record again, and anything they enter overwrites it. Is there a way to submit and force a new record to be created?

Thanks!

Re: Submitting an InfoPath 2003 form back to an Access database

Clay Fox — Wed, 19 Sep 2007 14:58:18 GMT

If you open up the data connections.

Select the Main data connection for your form.

In the lower window it will show the details and it will say recieve only or submit and recieve.

If it says submit then you are all set and you just need to add a submit button or trigger it somehow and the data will get saved back to your table.

One thing to remember with the basic form is that it is not very smart and will write all data back into your table. So if you are manipulating data in your form which is in the data fields then it will update your table with this which you may not want.

If submit is not listed as an option then your table is not setup correctly with a primary key. You should be able to set the Primary key and then modify the data connection and go through the steps again without starting over.

Re: Submitting an InfoPath 2003 form back to an Access database

m181354 — Wed, 19 Sep 2007 14:48:19 GMT

I already have the form connected to an Access database to receive information(i didn't see an option for submit). I created it from an extisting Access database so it would setup the query options for me. I connect to quieries I wrote in Access for dropdown boxes and to fill in most areas of the form. Users fill out comment boxes that I created in a FormData group.

I need to save one field to the same table that the Main form is connected to(using a query to get the data to the form). Is there an easy way to do this. Can I change my connection to the Access database from Receive to Submit and Receive?

You saiid...If it is simple and you just need to submit to one table then it may be a matter of reconfiguring your form to submit to the one table and then use secondary connections to pull the data from other tables or sources.

How do you do this?

Re: Submitting an InfoPath 2003 form back to an Access database

Clay Fox — Wed, 19 Sep 2007 13:46:03 GMT

So you already have your form connected to an Access database, is this to submit or just to recieve information?

Is this a different table you wish to update? If so then yes you would need to use Web Services, SQL Express and DBXL are great options.

The limitations in the standard form is that it has to be built from scratch with just one table that you can query and submit. With web services you can have multiple tables and configurations which you can query and submit.

If it is simple and you just need to submit to one table then it may be a matter of reconfiguring your form to submit to the one table and then use secondary connections to pull the data from other tables or sources.

Good Luck.

If you would like more information on DBXL you can email me.

Qdabra Database Accelerator Suite Version 2.1.2815 - Developer

Submitting an InfoPath 2003 form back to an Access database

m181354 — Wed, 19 Sep 2007 10:59:51 GMT

How do I Submit an InfoPath 2003 form back to an Access database? I just need update one field. Is the only and easiest solution to use the Qdabra Database Accelerator (DBXL)? II have my Main form connected to an existing Access database.