Macro to generate a table from query

T

Tony

how can i bypass the yes or no option during generating a table.

sendkey?

Thanks a lot.
 
K

Ken Snell

Use the SetWarnings action. Before you run the query, use this step:

Action: SetWarnings
Expression: No

After you run the query, I recommend that you use this step (although macros
usually turn this action back on automatically when the macro finishes):

Action: SetWarnings
Expression: Yes
 
T

tony wong

thanks for detailed explanation.


Ken Snell said:
Use the SetWarnings action. Before you run the query, use this step:

Action: SetWarnings
Expression: No

After you run the query, I recommend that you use this step (although macros
usually turn this action back on automatically when the macro finishes):

Action: SetWarnings
Expression: Yes
 

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

Top