update query

[denelson]

Is there a way to turn off that notice when you run an update query
that says "Are you sure you want to do this your about to update X
number of records... blah blah blah"

 

[Guest]

If you are running the update query from a macro or code module, you could
SetWarnings to No. WARNING: If you set warnings to off at the beginning of a
macro or module, be very, very sure to turn the warnings back on at the end.
Otherwise you won't receive other warnings until the database is shut down
and restarted.