ADO Error object - HelpContext Property

Home | About me | EXCEL VB Programming (XL97-2003) | ACCESS Programming | EXCEL VB.Net Programming | EXCEL Spreadsheet Functions Material Management  |  Guestbook
 

ADO Error object: HelpContext Property

Syntax

objErr.HelpContext

Returns a long value that is the context ID in the help file (if it exists) for the error.

The HelpContext property returns a long value that is the context ID of a topic in a Windows help system.
 
The companion HelpFile property returns a string that is the path and file name of the help file in a Windows help system.
 
Both of these properties allow you to interact with the Microsoft Windows help system. This involves calling the Windows API Help functions. If you do not have such access, the HelpContext property returns zero and the HelpFile property returns the empty string "".

 

Example

For Each objError in objConnection
   ErrorInfo = "Description; " & objError.Description & VbCrLf &_
      "Help Context: " & objError.
HelpContext & VbCrLf &_
      "Help File: " & objError.HelpFile & VbCrLf &_
      "Native Error: " & objError.NativeError & VbCrLf &_
      "Number: " & objError.Number & VbCrLf &_
      "Source: " & objError.Source & VbCrLf &_
      "SQL State: " & objError.SQLState & VbCrLf

   Debug.Print ErrorInfoNext