How to suppress query messages

  • Thread starter Thread starter JA
  • Start date Start date
J

JA

My macro runs delete and append queries. How can I
suppress the deafult messages like "You are about to run
a delete query ..." as I want to use the Windows
Scheduler to automate the processing? Please help.
 
just run "setwarnings no" before your query and then set it back
"setwarnings yes"
in VBA it will be docmd.setwarnings true/false
 
docmd.setwarnings(0) 'for off
docmd.setwarnings(1) 'for on
 
Back
Top