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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Suppressing "Do you want to save" message when closing the slideshow 0
VBA office 365 on windows 10 0
Need Help with Macro Security 1
suppress macro messages 1
Suppress warnings, but show error messages 3
Suppress Header/Footer 1
Improving Macro That Keeps First Letter 0

Top