How to avoid being prompted in access

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top