Global Error Handler[/

[kelele]

I have a fairly large VBA project built in Access. I was wondering if there was a way to make a global error handler for the whole project without having to use the On Error statement in all my procedures.

thanks,

kelele

 

[JoeMiller]

I Google-ized your question and came up with this

http://bpro.com/Misc/MC_error.htm

HTH Joe Miller
joe.miller@flotech.net

 

[JoeMiller]

Try this thread too...

thread702-70584 Joe Miller
joe.miller@flotech.net

 

[jlitondo]

The following link has quite an extensive explanation on global error handling.Seems to me like the trick is to capture each unique error (by error Number) triggered by an event on a form, and pass this on to your global error handling function in a module in order for the function to return either an access error message or a customised one.Still trying to work it.

http://www.saicomsystems.com/tip1999V12.htm