update query

  • Thread starter Thread starter denelson
  • Start date Start date
D

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"
 
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.
 
Back
Top