Disable message boxes?

[Jerry]

I have a macro that activates a couple queries. The first
one makes a new table, the second one updates that new
table and then outputs it as an .rtf file.

As you can imagine, I get several message boxes in the
process, such as "you are about to update," "you are about
to create a new table," etc.

Once I know that it works properly, I'd like to disable
those message boxes so as to not confuse the end user.
They can throw them into panic mode!

Can it be done?

Thanks in advance.

Jerry

 

[Jim/Chris]

In the macro use the SetWarnings action.
"Off" suppress messages.

Jim

 

[Steve Schapel]

Jerry,

Jim's advice is correct, except that the setting for the macro argument
for the SetWarnings action is 'No' rather than 'Off'.

Just put this action into the macro before the first of the queries.

 

[j]

Thanks steve, I guess my mind is starting to shut down
this late in the day.

Jim