How to remove OK buttons during query

T

test guy

Can someone point me to a tutorial on how to remove the confirmation
dialogues (OK buttons) that might occur when a query is running.. I want
them to all default so I don't see them..
 
K

Ken Snell [MVP]

You can turn them off in Tools | Options menu.

However, just remember that they won't turn back on unless you manually turn
them back on.
 
D

Douglas J. Steele

Either DoCmd.SetWarnings False before you run the query (and
DoCmd.SetWarnings True after), or else use the .Execute method of either the
database or QueryDef object.
 
Top