SetWarnings

[Chris]

Hello guys,

I feel like a right silly. I regularly run several action queries and but
never ventured to macros and VBA. However, it seems that it's not that
complicated to set up a macro to run all them queries in one go. Thanks to
the help found here in the fora I managed to make the macro too. Then I got
the warning messages, for which I found the help too. My problem is that I
cannot find the action SetWarnings in the macro action list. I've checked the
list of actions like a dozen times now but it just simply isn't there. I use
access 2007. Anyone knows how to find it or perhaps there is another way I
can sneak it into the code somehow? Thanks in advance!

 

[Kardan via AccessMonster.com]

Hi Chris

In macros it is the action SetWarings, in VBA it can be done with DoCmd.
SetWarnings. In both cases to suppress warnings this should be set to false.

Remember to set them back to True at the end of your macro or code otherwise
all future warnings will be suppressed.

Regards

Richard

 

[Steve Schapel]

Remember to set them back to True at the end of your macro or code
otherwise
all future warnings will be suppressed.

Just to be pedantic here, Richard... this is not necessary in a macro.
Warnings automatically reverts to Yes at the conclusion of the macro.

 

[Steve Schapel]

Chris,

Click the 'Show All Actions' button on the macro design ribbon.

 

[Steve Schapel]

Remember to set them back to True at the end of your macro or code
otherwise
all future warnings will be suppressed.

Just to be pedantic here, Richard... this is not necessary in a macro.
Warnings automatically reverts to Yes at the conclusion of the macro.

 

[Steve Schapel]

Chris,

Click the 'Show All Actions' button on the macro design ribbon.

 

[Steve Schapel]

Remember to set them back to True at the end of your macro or code
otherwise
all future warnings will be suppressed.

Just to be pedantic here, Richard... this is not necessary in a macro.
Warnings automatically reverts to Yes at the conclusion of the macro.

 

[Steve Schapel]

Chris,

Click the 'Show All Actions' button on the macro design ribbon.

 

[Steve Schapel]

Chris,

Click the 'Show All Actions' button on the macro design ribbon.

 

[Steve Schapel]

Remember to set them back to True at the end of your macro or code
otherwise
all future warnings will be suppressed.

Just to be pedantic here, Richard... this is not necessary in a macro.
Warnings automatically reverts to Yes at the conclusion of the macro.

 

[Steve Schapel]

Remember to set them back to True at the end of your macro or code
otherwise
all future warnings will be suppressed.

Just to be pedantic here, Richard... this is not necessary in a macro.
Warnings automatically reverts to Yes at the conclusion of the macro.