How to avoid being prompted in access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

quocvnf - 24 Apr 2006 03:15 GMT

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.

Reply to this Message

tina - 24 Apr 2006 05:28 GMT

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

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

Reply to this Message