Error Handling

[richard]

Is it possible to have the standard Error Handling text, that Access creates
with Command Buttons etc, created when I create my own private sub.

Or is it possible to have a public sub that acts as an error handler that I
can use instead.
I am new to access and have created a database which currently gives the
user the chance to 'debug' my code when an error occurs(Oh my god that was
fun to start with). I am now going back through all of the 'private subs' to
enter the error handling and I am finding this laborious. So am looking for
an easier/quicker/more efficient option.

Thanks

Richard

 

[Allen Browne]

You do have to add error handling to each individual procedure.

These error handlers can call a generic function.
Here's an example of how to build such as function that logs the errors to a
table:
Error Handling in VBA
at:
http://allenbrowne.com/ser-23a.html

There are tools around that can do that with a mouse click.
My favorite is from www.mztools.com
The VBA version is configurable, so you can call your own error handler.