error numbers and their descriptions

[wazz]

is there a place that lists all the error numbers and their descriptions?

 

[oldaf294]

Yes!.......

 

[oldaf294]

just kidding.
here is a link to list them
http://support.microsoft.com/?kbid=268721

 

[wazz]

tnx much.

 

[MarkK]

This'll list VBA errors...

Sub VBAErrMsgs()
On Error GoTo handler
   Dim i As Long
   
   For i = 1 To 746
      Err.Raise i
   Next i
   Exit Sub
   
handler:
   If Err.Description <> "Application-defined or object-defined error" Then
      Debug.Print Err & " " & Err.Description
   End If
   Resume Next

End Sub

 

[wazz]

tnx again.

FYI:
- the database (from microsoft link) lists over 32,000 errors; 2348 unique.

- how did you come up with 746? by running it and seeing the total, i presume, or some other way?

w.

 

[MarkK]

Yup. Ran it to 5000 but it topped out at 746.
I later found an Access help entry under "Trappable Errors", which also lists those errors up to 746. In addition it lists errors 31001 to 31027 (or something), but I could not raise those in code and return the err.Description noted in the help article.