I can not turn off delete query confirm

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

Guest

When I uncheck the confirm checkboxes (tools, options, edit,view) confirm, it
still asks me for a confirmation "Yes".
 
By your path I'm not sure what you checked

Tools > Options > Edit/Search (Tab) > Action Query (UnCheck it)
 
I unchecked all three but it still asks for a confirmation.
The only way I can find to stop this is to do a "Set Warning - Off" in
a macro before running the query.

Thanks
 
I unchecked all three but it still asks for a confirmation.
The only way I can find to stop this is to do a "Set Warning - Off" in
a macro before running the query.
Click to expand...

Yes... try putting Setwarnings in the left column, False in the right.

Take a look at Help for the Setwarnings operation. That's exactly how
it works - Setwarnings is a macro step.

John W. Vinson[MVP]
 
You must log in or register to reply here.

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

Access Dcount (multiple criteria) 3
Turning off action query confirmation messages 1
Confirm Table Deletion Box in Make Table Query 2
'Count' query not working 5
STOP Delete existing table confirmation 2
Simply query? 9
Query to find missing data 4
Turning off the confirmation messages 4

Back
Top