Global error handler

[Gary G. Little]

Is there, in ACCCESS 2007, and/or VB a global error handler? I've checked
the docs but not sure on the feasibility of this. I've seen On Error and
OnError, and a discussion excepotion handling, but again, I'm not sure on
the implementation of error and exception handling.

 

[Allen Browne]

You must add the error handling to each routine. There's not a way to just
make it automatically go to an exception handler without doing so.

In each routine, you can call a generic error handler. Here's an example of
how:
Error Handling in VBA
at:
http://allenbrowne.com/ser-23a.html
The example calls a routine that logs the errors to a table, where you can
read/report them later.

There's a good add-in for VBA that adds the error handler to a routine with
a single mouse click. see:
http://www.mztools.com/v3/mztools3.aspx

 

[Gary G. Little]

Thanks Allen. I suspected that was the answer, but being new to Access I was
not sure.

--
The personal opinion of
Gary G. Little

You must add the error handling to each routine. There's not a way to just
make it automatically go to an exception handler without doing so.

In each routine, you can call a generic error handler. Here's an example
of how:
Error Handling in VBA
at:
http://allenbrowne.com/ser-23a.html
The example calls a routine that logs the errors to a table, where you can
read/report them later.

There's a good add-in for VBA that adds the error handler to a routine
with a single mouse click. see:
http://www.mztools.com/v3/mztools3.aspx