Error Codes

J

JK

Does anyone know where I could download a current list of VBA Error Codes? I
want to create a table with the error code and error description but I can't
seem to find an updated list. I'm using Access 2003 - WinXP.

Thx!
JK
 
K

Klatuu

You don't really need such a table. There are a couple of ways you can get
the information from Access.

First, the following will return the error description:

=AccessError(5)

If you are in an error handler routine and want to display the error
description, you can use something like:

MsgBox Err.Number & " " & Err.Description & " Has Occurred"
 
L

Linq Adams via AccessMonster.com

I have a small database that I made for just the problem.

You can lookup an error's description by its number or search the table by
entering keyword(s) to get the error number.

If you'll email me at

AccessGuy [ at ] wildmail [dot].com I'll zip a copy up and send it to you.

This is an email account I use only for doing this kind of thing, so don't
anyone get torqued!
 
Top