How to avoid being prompted in access



Please help me to avoid being prompted "The existing table will be deleted
before you run the make table query" when I run macro and inside this macro I
run the command "Open make-table queries". Althought I turned off the check
box "Action query" under "Confirm" label in "Edit/Find" options of Tool
Menu, thank you.




add a SetWarnings action to your macro, immediately preceding the OpenQuery
action, to turn warnings off. warnings will be turned back on automatically
when the macro ends; but if you have additional actions in the macro, you
may want to use SetWarnings to turn warnings back on immediately after the
OpenQuery action - just in case one of those additional actions fails, and
halts the query.


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