Error messages on append queries

[Jason Potter]

When you run an append or make table query you receive
several messges (ei: you are about to run an append etc...)
Is there any way to turn off these messages?

 

[Roxie Aho]

DoCmd.SetWarnings False in an event procedure on the form
from which you run the query. I find it good practice to
set warnings back to true once the procedure has un in
case I want warnings elsewhere.

Roxie Aho
(e-mail address removed)

 

[Van T. Dinh]

Use the Menu Tools / Options .../Edit_Find tab / Confirm pane and set the
appropriate confirmation.

Beware of accidental changes / updates / deletions.

If you use code to run the Query, you can temporarily stop the warning
(Using SetWarnings Method), run your updates and then reset the confirmation
just after your intentional updates. Alternatively, you can use the Execute
method which does not require confirmation.