Where is the complete list of Err.Number and Err.Description in VBA? (1 Viewer)

[AccessPractice]

Hi
I have tried finding the list on Microsoft website but found some partial lists
of Error from which sometimes don't have the value I need to get information.
So Anyone who has it please posts a link to the complete list of Err Number and Description.
Thank you

 

[moke123]

http://www.fmsinc.com/microsoftaccess/errors/ErrorNumber_Description2010.html

 

[AccessPractice]

Thank you moke123! It helps!
However, I found an error such as "Err.Number = -2147467259"
which is not included in your link.

 

[MarkK]

There is no fixed set of ALL errors. I can write code that raises an error as follows . . .

Err.Raise -1234, "My Code", "This is a custom error"

Copy and paste that code into the immediate pane on your machine, and run it, and you can raise that same error on your machine. Obviously there will be no external reference that will tell you what that error is.

Also, I can override VBA errors. We know VBA error 13 is a Type Mismatch error. But we can run this code in VBA . . .

Err.Raise 13, "MyCode", "Not a type mismatch error."

. . . and raise Error 13 with a different source and description.

Hope this helps,