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
 

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

Suppress warnings, but show error messages 2
suppress macro messages 1
Disable Error Message when using DoCmd.RunSql 2
Access2000: Suppressing messages for Append/Delete queries 5
remove action query message 3
Running parameter queries from VBA, suppressing parameter prompts 4
Disable "Run Query" message in status bar 2
How to suppress make table warning 2

Back
Top