Bypass Msg boxes?

  • Thread starter Thread starter Anna
  • Start date Start date
A

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




.
Click to expand...
 
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
 
Back
Top