Unbound form writing back to table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roll_Tide315 - 12 Mar 2008 16:02 GMT

I have a form with two text boxes. I want to take what the user enters into
those text boxes and write that data back to a table. I know I bound those
text boxes to the table but I want to keep them unbound and use some kind of
VBA code to say AFTER UPDATE, write back to a table I specify.

Reply to this Message

Allen Browne - 12 Mar 2008 16:09 GMT

Provide buttons for Ok and Cancel on your form.

In the Ok button's Click event procedure, exeute an append query statement
to add the data to the desired table.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a form with two text boxes. I want to take what the user enters into
> those text boxes and write that data back to a table. I know I bound those
> text boxes to the table but I want to keep them unbound and use some kind
> of
> VBA code to say AFTER UPDATE, write back to a table I specify.

Reply to this Message

Roll_Tide315 - 12 Mar 2008 16:17 GMT

How do you refer to a form within a query? I thought you could only query
data that is stored in a table or in another query. How do you tell the query
to get the data from the form and append to a table?

>Provide buttons for Ok and Cancel on your form.
>
[quoted text clipped - 6 lines]
>> of
>> VBA code to say AFTER UPDATE, write back to a table I specify.

Reply to this Message

Allen Browne - 12 Mar 2008 16:31 GMT

We are not talking about a saved query here.

Build a string containing a SQL statement, and Execute it.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> How do you refer to a form within a query? I thought you could only query
> data that is stored in a table or in another query. How do you tell the
[quoted text clipped - 14 lines]
>>> of
>>> VBA code to say AFTER UPDATE, write back to a table I specify.

Reply to this Message

Roll_Tide315 - 12 Mar 2008 17:16 GMT

Would you mind explaining? I am just starting to learn SQL. To make things
simple, on my form i have 2 text bozxes: first name and the second last name.
When the user enters a name, I want the name to appear a table I made called
User name. Could you please walk me through buidling the SQL statement? Thank
you!

>We are not talking about a saved query here.
>
[quoted text clipped - 5 lines]
>>>> of
>>>> VBA code to say AFTER UPDATE, write back to a table I specify.

Reply to this Message

Roll_Tide315 - 12 Mar 2008 17:18 GMT

Would you mind explaining? I am just starting to learn SQL. To make things
simple, on my form I have 2 text boxes: first name and the second, last name.
When the user enters a name, I want the name to appear a table I made called
User name. Could you please walk me through buidling the SQL statement? Thank
you! I realize I am making this hard on myself by not binding the form's text
boxes but I want to learn the SQL part.

>We are not talking about a saved query here.
>
[quoted text clipped - 5 lines]
>>>> of
>>>> VBA code to say AFTER UPDATE, write back to a table I specify.

Reply to this Message

Allen Browne - 12 Mar 2008 17:33 GMT

Here's an example of exeucting a query statement:
http://allenbrowne.com/ser-60.html

If you really are starting out, you should investiage bound forms first.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Would you mind explaining? I am just starting to learn SQL. To make things
> simple, on my form I have 2 text boxes: first name and the second, last
[quoted text clipped - 17 lines]
>>>>> of
>>>>> VBA code to say AFTER UPDATE, write back to a table I specify.

Reply to this Message