How can warnings in queries be set to auto reponse (i.e "yes")?

B

Bob

When executing a query through a macro, how can I automatically set the
response to the warning messages to "yes", instead of having to answer each
question separately. I have seen this done, but have not found an operators
manual or help response that shows how to preset the responses, so that the
macro operates without requiring user interactive response to these pop-up
warnings, requiring a yes or no, such as "You are about to append ## records
to Table "XXX". Do you wish to continue? (Yes or No).
 

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

Set Warnings in MS Access 2007 3
Copy DB file to new location, and open without warnings 9
how to add a textbox if user chooses yes in response to msgbox. 0
How do I add "yes" or "no" to branches in decision tree? 4
How do I set up a form that can be filled in on screen? 3
How to run auto-open macro in Excel 2007? 3
Which table to put fields in? 4
how to change color gradients in a bar chart 0

Top