On Error...GoTo 6

[graphix03]

Hi,

Does anyone knows when to code this On Error GoTo code...?
I want to do it right, but I'm confused when/where to
code the error code so when there's an error it knows what to do...so, do you code it in ALL sub routines and functions, or just on certain one? I read a few books, but
they have the error codes just on some procedure for command button, but not all.

any input would be appreciated. thanks much.

 

[dilettante]

You can run into additional restrictions for the Number to use with Err.Raise as well:

PRB:Unexpected Results When Raise Method Propogates OLE Errors

 

[strongm]

Which merely reinforces my earlier point about vbObjectError...

 

[strongm]

What, no-one curious enough to investigate vbObjectError?

 

[dilettante]

Hmm... you mean the fact that vbObjectError == FACILITY_ITF?

 

[strongm]

Yep

 

[BobRodes]

Ok, ok, so I looked it up. FACILITY_ITF is the base constant for the range of errors reserved for a component's interface. The hex value of vbObjectError is 80040000. The 8 sets the severity bit which means an error. The 4 sets the facility code to interface.

This begs the question: is it a bad idea to evaluate err.number, and assume that if it's < 0 that the error is a vb object error? I'm beginning to think that there might be other facility codes that I'm unaware of that might evaluate to less than 0.

Thx

Bob

 

[strongm]

Start here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/com/htm/error_5g6r.asp

(the second section - Codes in FACILITY_ITF - explains the real reason behind the problem discussed, but not explained, in the knowledgebase article that dilettante provides)