VBA Error Handler

[David S.]

Hello everyone,

I have XP Developer and would like to use the VBA Error
Handler referenced in the documentation however I cannot
locate it. Any ideas are greatly appreciated. Thanks
and happy holidays.

David

 

[Ken Snell]

Error handling can be done by putting statements in your code that tell
ACCESS where to "go" when an error occurs. These statements are similar to
the following:

On Error Resume Next

On Error GoTo Err_LabelName

You then put code in that location to test for the type of error (if that's
what you want) and/or to display messages re: the errors and/or to do
something to fix the error and then to continue with the code at some point.

Help has examples of these. Post back with specific questions.

 

[Scott McDaniel]

The add-in is called "Code Commenter and Error Handler", IIRC. From the VBA
window, click Add-ins. The addin must be installed (I'm not sure if it was
an option when installing Access, so you may not have it on your system).

Be careful; I had some issues with this add-in (putting code in the wrong
places, separating code modules with comments, etc) ... do this on a COPY of
your database until you make sure it does what you want. FWIW, I use
CodeCrafter from http://www.codecrafter.com/ ... best $15 I spent in a long
time!!

 

[Douglas J. Steele]

You might want to take a look at MZTools
http://www.mztools.com/

The price is even better! <g>

 

[David S.]

Thanks. That was a big help from all of you.
David

-----Original Message-----
You might want to take a look at MZTools
http://www.mztools.com/

The price is even better! <g>

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Handler", IIRC. From the
VBA etc) ... do this on a COPY
of $15 I spent in a
long


.