display error message

[pierre]

Hi all,

I am logging the error in a program.
I have a table with a 100 char text field
On a form i display a list of error or events that happened since the
program sart, with a timestamp.

I would like to replace the text field by a number
and on my form i will put the error number and generate the description

How can i link the error description to the error number?

i need a function like desc=errNbToDesc(errorNumber)

any hint?

Regards,
Pierre

 

[Allen Browne]

Log the error number and the error description into your table.

There's an example of how to do that in this article:
Error Handling in VBA
at:
http://allenbrowne.com/ser-23a.html