We're trying to automate (schedule) many of our macros.  In this way, we 
will be executing the macros as unattended operations.  Rather than user 
popups, I would prefer logging of the errors and returning error codes.

Does anyone have input, experience, or reference to documentation on this?

Thanks!
Best regards,
Len Nagy

If you are truly using Macro's then you are not going to be able to trap
any errors.  The only way to trap the errors is to convert the macros to
VBA and Access provides a Wizard to do this.  Now if your macros append,
delete, or update records via queries, you can turn the Access messages
off by using the Macro Action "SetWarnings" to off and on.  If you
SetWarnings to Off make sure you SetWarnings to On before the macro
action is complete. 

John V. Ruff - The Eternal Optimist :-)
Always Looking For Contract Opportunities

www.noclassroom.com
Live software training
Right over the Internet

Home:  xxx.xxx.xxxx
Cell:  xxx.xxx.xxxx
9306 Farwest Dr SW
Lakewood, WA 98498




-----Original Message-----
From: Len Nagy [mailto:lnagy@a...] 
Sent: Wednesday, October 30, 2002 8:57 PM
To: Access
Subject: [access] access macro, need to disable the user pop ups...


We're trying to automate (schedule) many of our macros.  In this way, we

will be executing the macros as unattended operations.  Rather than user

popups, I would prefer logging of the errors and returning error codes.

Does anyone have input, experience, or reference to documentation on
this?

Thanks!
Best regards,
Len Nagy