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]
 
Back
Top