clearing confirm boxes does not stop warnings

G

Garthh

I am using a make table query that overwrites the existing table each time it
is run.
I have cleared the confirm boxes under options yet the warning that you are
about to delete the existing table continues to show
 
O

Ofer

Just to make sure that this what you did
In the menu bar select
Tools > Options > Edit/Search (Tab) > Confirm Action Queries (remove the
selection)

==================================
Another method will be, before running the action query, set the warnings to
false

Docmd.SetWarnings False
Docmd.OpenQuery "QueryName"
Docmd.SetWarnings True
 
G

Garthh

Thank you
Yes that is the procedure I used and was wondering why it didn't stop the
messages. To get them to stop I had to use the doCmd.SetWarnings False and
then turned them on when closing.

Thanks again
 
Top