how do I hide warning messages in Macros in Access 2007


B

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?
 
K

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

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

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
 
B

biggles

Steve, you're a star, thank you!

Steve Schapel said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top