RE: how do I hide warning messages in Macros in Access 2007
KARL DEWEY
Add action 'SetWarnings' - No in the new row at top and 'SetWarnings' - Yes
in the new row at bottom.
--
KARL DEWEY
Build a little - Test a little
"biggles" wrote:
> when running macros with multiple queries in Access 2007 I currently have to
> answer Yes/No to warning messages ("are you sure you want to run this ?"). In
> Access 2000 this coul dbe turned off with an extra line inside the Macro but
> that doesn't work in 2007. I have been able turn it off for the entire
> appliction on a single PC but when deploying a database to another user who
> only has Access Runtime for example this option isn't available. Is there a
> way of stopping these messages for an entire database or by macro within that
> database like there was in 2003?
>
biggles
Unfortunately, in 2007 there is no option "SetWarnings" in the list in
design view.
That was the way I used to do it in 2003. Is there a way this option can be
added by users in design view so that it can be used? It's not allowing
anything apart from the listed options with the current settings.
Steve Schapel
Click the Show All Actions button on the Show/Hide group on the Macro
Design Tools tab.
By the way, you don't need to put a SetWarnings/Yes action in the
macro... the warnings automatically reverts at the end of the macro
--
Steve Schapel, Microsoft Access MVP
