how do I hide warning messages in Macros in Access 2007

[biggles]

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?

 

[KARL DEWEY]

Open the macro in design view, insert a new row at top and anothe at bottom.
Add action 'SetWarnings' - No in the new row at top and 'SetWarnings' - Yes
in the new row at bottom.

 

[biggles]

Thank you for your prompt response Karl !
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]

Biggles,

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

 

[biggles]

Steve, you're a star, thank you!

Biggles,

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

 

[paul.mccracken1962]

Steve, you're a star, thank you!

Geniuis!! This has saved me hours.