VBA, Error Handling (Handle by number)

Error Handling (Handle by number)

Author	Message
Earl Gipso #1 / 5	Error Handling (Handle by number) All, In a single module I have the statement "On Error Goto MajorError." The label MajorError has underneath, a Select Case Err.Number series of known errors that will occur and should handle each one differently. Why does Access only find the first error and then by default gives me an error description of the second instead of handling it at the MajorError label and corresponding number? This can't be that hard. What am I missing? EG
Fri, 07 Jun 2002 03:00:00 GMT

Dirk Goldga #2 / 5	Error Handling (Handle by number) I don't understand. What is it you say is happening? -- Quote: >All, >In a single module I have the statement "On Error Goto MajorError." The label >MajorError has underneath, a Select Case Err.Number series of known errors that >will occur and should handle each one differently. Why does Access only find the >first error and then by default gives me an error description of the second >instead of handling it at the MajorError label and corresponding number? >This can't be that hard. >What am I missing? >EG
Fri, 07 Jun 2002 03:00:00 GMT

Earl Gipso #3 / 5	Error Handling (Handle by number) Two errors may occur in this module (3078 & 3043). They may occur one right after the other. The On Error Goto MajorError seems to work only once and then the default message "Run Time Error,etc. appears for the second error versus going to the MajorError label and dealing with the second error (Select Case err) . I hope this clearer. EG Quote: >I don't understand. What is it you say is happening?
Sat, 08 Jun 2002 03:00:00 GMT

Dirk Goldga #4 / 5	Error Handling (Handle by number) I wonder if you have an "On Error" statement in your error handler that is disabling the error trap when you resume. Also, how do you resume execution after the first error? Would you like to post the code? -- Quote: >Two errors may occur in this module (3078 & 3043). They may occur one right >after the other. The On Error Goto MajorError seems to work only once and then >the default message "Run Time Error,etc. appears for the second error versus >going to the MajorError label and dealing with the second error (Select Case >err) . I hope this clearer. >EG >>I don't understand. What is it you say is happening?
Sat, 08 Jun 2002 03:00:00 GMT

Earl Gipso #5 / 5	Error Handling (Handle by number) I made an "ugly" work around for the time being because of time constraints. The module is quite large so I going to do some tinkering with a smaller version "inducing errors". I am probably missing something obvious. I will post the smaller version if when I return from the holidays if I still can't make sense of it. Thanks for you help. EG Quote: >I wonder if you have an "On Error" statement in your error handler that is >disabling the error trap when you resume. Also, how do you resume execution >after the first error? Would you like to post the code?
Sat, 15 Jun 2002 03:00:00 GMT

Page 1 of 1

[ 5 post ]