I can not turn off delete query confirm

W

Whiteware

When I uncheck the confirm checkboxes (tools, options, edit,view) confirm, it
still asks me for a confirmation "Yes".
 
O

Ofer Cohen

By your path I'm not sure what you checked

Tools > Options > Edit/Search (Tab) > Action Query (UnCheck it)
 
W

Whiteware

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
 
J

John Vinson

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