How to avoid being prompted in access

G

Guest

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

tina

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.

hth
 

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

schedule task macro failes to complete due to persistent prompting 2
Hide Message in Action queries 7
Way to avoid 'halt' in macro 4
Not prompted when running append/make-table queries? 8
Turn_off confirm message"Table will be deleted" inside a Macro 2
How to avoid having to click Allow each time 2
Set Display Control for a Table Yes/No Field 5
Dismiss a dialog box 3

Top