Updating multiple records

[Guest]

I am using an update query to update multiple records from a form.
Whwen I run the query I get the message warning me that I am updating records.
How do I prevent that message?

 

[bsmith59]

I am using an update query to update multiple records from a form.
Whwen I run the query I get the message warning me that I am updating records.
How do I prevent that message?

Several ways. If it's just you using the database on your PC, you can
do the following:

1) Go to Tools>>Options, then click on the Edit/Find tab.
2) In the "Confirm" box at right, uncheck the boxes corresponding to
the actions you don't want to have to confirm. In this case, "Action
Queries"

Note that this will turn off the message universally.

Alternatively, you can turn the warning off from VBA using
"docmd.setwarnings false" which will also turn warnings off
universally until you set it back to "true".

Cheers,
Brandon
http://accesspro.blogspot.com (access tips for non-programmers)