macros query prompts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please let me know how a macro can me made to skip the prompts associated
with a make table/delete table query
 
neeraj.

neeraj said:
Please let me know how a macro can me made to skip the
prompts associated with a make table/delete table query
Click to expand...

Use the SetWarnings action.
 
Thanks, it helped but not entirely. My macro has the following components now:
1st row: make table query
2nd row: set warnings (set to "no")
3rd row: make table query
4th: set warnings (no)
5th: delete query
6th: set warnings (no)
What is happening now is that when I run the macro, it asks me for only one
prompt now, it is associated with the very first make table query and it
says: "the existing table will be deleted...do you want to continue".
Interestingly, it does not issue the same warning for the second make table
query. Is there a way that I can disable this confirmation message
 
Thanks, I got to know that in the meanwhile too, but why would you want to
set the warnings to Yes in the end. Even without setting the warnings to yes
in the end, the individual make table query when run was generating
confirmation messages.
 
Neeraj,

There is no need to SetWarnings to Yes at the end.

Make your macro like this...

1. SetWarnings / No
2. OpenQuery / (your 1st make-table)
3. OpenQuery / (your 2nd make-table)
4. OpenQuery / (your delete query)
 
Back
Top