clearing confirm boxes does not stop warnings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make table warning 3
Confirm Table Deletion Box in Make Table Query 2
Make-Table query simple question 1
STOP Delete existing table confirmation 2
Make Table Query Popups 9
File Download - Security Warning 5
Access 2000 Make Table Query Warning Box 5
turning off action queries 3

Back
Top