Bypass Msg boxes?

[Anna]

Hi,

I have a macro that runs a series of queries to update
data in a table and make new tables. At the moment, I am
getting all the associated message boxes (e.g. "You are
about to paste 23 rows into a new table...") - is there
any way I can run the macro without showing these boxes?
Or a way I can automatically press "OK" to them all?

thanks,

Anna

 

[Cheryl Fischer]

Before the actions to run your queries, insert the SetWarnings action and
set its value to False. After the actions to run your queries, insert the
SetWarnings action and set its value to True.

 

[Anna]

That's great - thanks.

Anna

-----Original Message-----
Before the actions to run your queries, insert the SetWarnings action and
set its value to False. After the actions to run your queries, insert the
SetWarnings action and set its value to True.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX




.

 

[Steve Schapel]

Wolfgang,

Just as a matter of interest, it is not necessary to use SetWarnings,
Yes at the end of the macro. The Warnings are automatically reset to
Yes at the end of the macro anyway.

- Steve Schapel, Microsoft Access MVP