Newbie Questions

Re: Submitting Information back to an Access Database

kddove — Tue, 29 Jul 2008 20:06:26 GMT

I have an Access DB. I have a form with three fields for changing vendors per username.

In the access database I have a unique username and a unique vendor. What I want to do is let the users change their vendor instead of me having to do it... so I wanted to write something like:

if username == username and

vendor == vendor

then

new vendor == vendor

So I have three slots on the form. One for username, one for old vendor, one for new vendor and then a submit button. I want to make sure it only updates the vendor where the username is specified using an access database. Is this possible, if so how?

Re: Submitting Information back to an Access Database

m181354 — Tue, 18 Sep 2007 18:45:54 GMT

I have a similiar situation as below with an InfoPath 2003 form...when you said in an earlier post that... They can then modify any of the results. Submitting the form then saves the contents of dataFields only back to the database...does that work for 2003...I don't see where I can submit back to the Access database.

Earlier Post.... When you create a main connection for a database you should end up with a folder called myFields which should have 2 sub folders, one called queryFields, one called dataFields.

You use the queryFields like you would in "Filter by Form" in access. Then query the main connection. This populates the dataFields.

They can then modify any of the results. Submitting the form then saves the contents of dataFields only back to the database.

Re: Submitting Information back to an Access Database

Grey Owl — Tue, 28 Nov 2006 20:18:10 GMT

Ah, yes... Thanks for that :)

Re: Submitting Information back to an Access Database

Stavi — Tue, 28 Nov 2006 09:29:48 GMT

When you create a main connection for a database you should end up with a folder called myFields which should have 2 sub folders, one called queryFields, one called dataFields.

You use the queryFields like you would in "Filter by Form" in access. Then query the main connection. This populates the dataFields.

The can then modify any of the results. Submitting the form then saves the contents of dataFields only back to the database.

You can also add extra fields to help your form but these will appear in myFields but outside the other 2 folders. Any contents of these fields will be lost if you do not save the form to a library or somewhere else.

Yes if you do not change the contents of dataFields and try to submit you will get an error.

I hope that made sense

Re: Submitting Information back to an Access Database

Grey Owl — Tue, 28 Nov 2006 06:28:47 GMT

I have got the main connection, but each time I submit the data back to the database, I get an error that tells me that I have not any information that has changed. When I submit to the db, am I submitting all the data in the form to the db?

Re: Submitting Information back to an Access Database

Stavi — Mon, 27 Nov 2006 14:20:54 GMT

Only the main connection can be submitted to a database.

When you submit to a database every field in the main connection under dataFields is submitted, you cannot specify single fields

Submitting Information back to an Access Database

Grey Owl — Mon, 27 Nov 2006 13:34:19 GMT

Hi guys,

I am currently having a problem with a form I have developed in Infopath 2007. It is a leave application form and I have used a basic access database for this. Once a department has been chosen, the user can then choose their name provided they are in that department. From here, based on the user name, the form is automatically populated with their details like email, extension as well as the details of their manager. The form is also populated with the amount of leave that each employee has. The user then chooses the kind of leave that they want and this does the calculation and gives a new field with the ammended leave value. I am doing a dual submit then, one to a sharepoint library and the other back to the access database.

It is this submitting back to the database that I am having a problem with. I am not to sure how to specify that the "newleavebalance" boxes are the ones that need to be submitted back to the database so that the database shows the new leave amounts.

Any help would be greatly appreciated

Thanks
Darren