Trapping errors

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

How do write a piece of code that traps VBA error messages and ignores
them?
See my post on 22/07/07 about an Automation error message
Thanks
Tony
 
Use "On Error" and "Resume Next".

If you are wanting to ignore just a specific error, make sure you check for
that particular error number before just ignoring it.

The better solution would be to fix whatever is causing the original error
if possible.
 
Thanks for that. The error is something to do with "Automation" which I
don't understand. It doesn't seem to affect the running of the database
though?
Cheers
Tony
 
Back
Top