Error Handling

[Russ9517]

I've wrote a error handling function but is there a way of getting an access database to call this function without using on error in every procedure.
Thanks

 

[boblarson]

no, you must insert the On Error GoTo piece in each. But, if you go get MZ Tools (which are free), you can simply enter each procedure and click a button to insert an error handler that you have pre-specified in the options.

 

[Mike Smart]

Error handling tutorial

Hi Russ

I've put a free tutorial on my site that will tell you everything you need to know about error handling. You do need to include it in every routine but it is very easy with a generic handler you can cut-and-paste. Such a handler is described here :-
Professional VBA - Error Handling
You'll also be interested in my programming standards for error handling that you can find here:-
The Rules - Constants, variable declaration, error handling and object destruction..

Hope this helps... Mike