By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

Good practise

100+
P: 184
Hi All

Just a question about good Access design.

I have a form which displays some information from different tables through comboboxes(which the user selects) and textboxes. There are then some fileds on this same form that the user fills in themselves.

My impression is that when the user then goes to save this form, all the fields on this form (whether populated from a different table or not) is then saved to a table that contains all fields that corresponds to all boxes on the form.

Hope I dont sound too confusing.

Thanks
Dec 5 '06 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
If the form is bound to the table and all the appropriate textboxes have their control source set to the appropriate fields then the record will be saved.

Mary

Hi All

Just a question about good Access design.

I have a form which displays some information from different tables through comboboxes(which the user selects) and textboxes. There are then some fileds on this same form that the user fills in themselves.

My impression is that when the user then goes to save this form, all the fields on this form (whether populated from a different table or not) is then saved to a table that contains all fields that corresponds to all boxes on the form.

Hope I dont sound too confusing.

Thanks
Dec 5 '06 #2

100+
P: 184
Thanks for the reply.

Well all the tables are linked from a IBM Iseries server(AS400) via a ODBC link.

So I have written a query to autofill x amount of the boxes on the form .This data is populated from a company employee table which I dont want write data back into, therefore the question for saving this data and other data for this same form to a complete new table

So I take it writing an INSERT INTO statement on a save button will be good for saving all this data?

Thanks
Dec 5 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Yes an "INSERT INTO ..." statement should work. Put the statement in a string variable (strSQL). Followed by a DoCmd.RunSQL strSQL statement.

Mary

Thanks for the reply.

Well all the tables are linked from a IBM Iseries server(AS400) via a ODBC link.

So I have written a query to autofill x amount of the boxes on the form .This data is populated from a company employee table which I dont want write data back into, therefore the question for saving this data and other data for this same form to a complete new table

So I take it writing an INSERT INTO statement on a save button will be good for saving all this data?

Thanks
Dec 5 '06 #4

100+
P: 184
Thank you very much

As always your help is much apprecited.
Dec 5 '06 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
Thank you very much

As always your help is much apprecited.
You're welcome.
Dec 5 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.