VBA Error Handler

  • Thread starter Thread starter David S.
  • Start date Start date
D

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
 
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.
 
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!!
 
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


.
Click to expand...
 
Back
Top