How to suppress query messages

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.
 
A

Alex Dybenko

just run "setwarnings no" before your query and then set it back
"setwarnings yes"
in VBA it will be docmd.setwarnings true/false
 
G

Guest

TooL>Options>edit/find tab/comfirm.
uncheck record changes, action query, delete query.
 
S

Samantha Rawson via AccessMonster.com

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 macro messages 1
Suppress warnings, but show error messages 2
remove action query message 3
How to suppress make table warning 2
Supressing warnings 8
Access2000: Suppressing messages for Append/Delete queries 5
Disable Error Message when using DoCmd.RunSql 2
Suppress Message pop-ups 10

Top