Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Global On Error Statement

Status
Not open for further replies.

kelele

Programmer
May 22, 2001
12
US
I have a fairly large VBA project built in MSAccess. I was wondering if there was a way I could code a global error handler without having to write On Error Statements in each procedure.

kelele
 
If you have a main procedure which calls all the other ones in your project, then I guess you just have to place your global error handler in the main procedure.
As far as I know, once an error occurs, an error handler is activated. If not found in the current procedure, then an error handler is activated in the parent procedure and so on.

Assaf
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top