Error numbers and descriptions

mikeco555

Registered User.
Local time
Today, 16:30
Joined
Jan 23, 2004
Messages
22
I have created a routine in VB that loggs erros to a table.
the only trouble is that I can't seem to log the error description into a a table.

no problem because I will put the descriptions in their own table and link them by err.number.

My question is then how to I go about getting all the possible VB application error numbers and their description.

Thanks,
Mikeco555
 
There's some code in the Help files to generate a table that lists all the trappable errors. Search the Help Files under Errors

But, why can't you log the Err.Description value?
 
I posted a sample db that will create a table listing most access errors accessandjeterrors.zip [at the bottom of the first page].

You should be able to grap the error description. You will have to format the error description field in the table as a Memo since the descriptions can exceed 255 characters. Or you could do something like =Left(Err.Description, 255)

Err.Number = error number
Err.Description = error description

HTH
 

Users who are viewing this thread

Back
Top Bottom