Alex & Access

February 11, 2011

Debug-friendly Error handler

Filed under: Access — access @ 1:48 pm

Recent discussion in Microsoft forums brings attention to old good trick, which was not mentioned here.

Each procedure should have an error handler; else you get application crash in runtime environment. But, when error occurs, you just get your MsgBox, describing error and that’s all. How to debug then? Add Resume statement after your Resume MyProc_End, and when you get MsgBox – press Ctrl+Break, move execution point to Resume and press F8 to go to Error line:

image

Ok, another option – is to use Global Error Handler, where you can even easier switch to error line.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: