By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,136 Members | 1,089 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,136 IT Pros & Developers. It's quick & easy.

Error Handling

Expert 100+
P: 1,892
Not sure if anyone has any knowledge of this. I am doing an insert from a form using VBA, I have an error handler that throws errors to a table. For some reason every time I run an insert I get an error with no description and an error number of 0 (zero). Currently, I'm using an "if" to trap errors <> 0

Dec 28 '06 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,494
I suspect you're not doing it correctly Aric, but post the code for me to check over if you would.
Doing it properly you would use :
Expand|Select|Wrap|Line Numbers
  1. On Error GoTo ...
  2. or
  3. On Error Resume Next
When the error handling is completed there must be a
Expand|Select|Wrap|Line Numbers
  1. Resume
statement of some sort to re-enable the error handler.
Dec 30 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.