alerts in macro's

[Guest]

when using an append query in a macro, how can you hide the alerts or dialog
boxes or make them automatically click yes

 

[Guest]

For first action use Warnings - Off. Then for last use Warnings - On.

 

[Steve Schapel]

Desiree,

Put a SetWarnings/No action in your macro before the first OpenQuery action.

 

[Guest]

Can you please put that in "stupid user" terms? I have been using macro's
sporatically and am currently drawing a blank on how to translate your
response. Thanks in advance for your patience.

 

[Guest]

See Steve Schapel's response.

 

[chuckHRC via AccessMonster.com]

Desiree- Whenever you "turn off" system warnings, as has been correctly
suggested, it's also a good practice to create your own error handling. You
might want to put a DCount statement as a condition one line below the append
query in the same macro to validate the record was added to your table and
have the condition=true fire your own message box, then set warnings back on.
The last thing you want is for a user to "think" a record appended when it
really didn't (they wouldn't know BECAUSE the warnings were turned off!) ...
just a thought from someone that's written several proprietary Access
applications.