Error messages

[Guest]

Where do I find a list of what errors = what number. For instance - I would
like to know what error number 2105 means.

 

[storrboy]

Where do I find a list of what errors = what number. For instance - I would
like to know what error number 2105 means.

In the 97 help files there is a topic named "Trappable Errors" not
sure if it's the same in newer versions.
Also there is a topic called "Determine the Error Codes Reserved by
Microsoft Access and the Microsoft Jet Database Engine" that contains
a complex looking function. If you copy and paste this into a modlue,
place the cursor somehwere inside the function and press the F5 key,
it will create a new table filled with errors related to Access and
Jet.
Look in the code for the line - For lngCode = 0 To 3500
You can increase the number of errors returned by increasing the
number 3500. I've set it as high as 10000, but you'll rarely see error
numbers that high. Five thousand should be ample.

 

[Dirk Goldgar]

Where do I find a list of what errors = what number. For instance -
I would like to know what error number 2105 means.

The error-listing function storrboy referred to makes use of the
built-in AccessError() function. You can check any particular error
number by calling it from the Immediate Window. For example:

------------
?AccessError(2105)
You can't go to the specified record.@You may be at the end of a
recordset.@@1@@1
------------

Or, in case you made a typo and were really curious about error 2501
(which is frequently asked about):

------------
?AccessError(2501)
The | action was canceled.@You used a method of the DoCmd object to
carry out an action in Visual Basic, but then clicked Cancel in a dialog
box.
For example, you used the Close method to close a changed form, then
clicked Cancel in the dialog box that asks if you want to save the
changes you made to the form.@@1@@1

 

[MARCO ANTONIO]

hola esto es una prueba

In the 97 help files there is a topic named "Trappable Errors" not
sure if it's the same in newer versions.
Also there is a topic called "Determine the Error Codes Reserved by
Microsoft Access and the Microsoft Jet Database Engine" that contains
a complex looking function. If you copy and paste this into a modlue,
place the cursor somehwere inside the function and press the F5 key,
it will create a new table filled with errors related to Access and
Jet.
Look in the code for the line - For lngCode = 0 To 3500
You can increase the number of errors returned by increasing the
number 3500. I've set it as high as 10000, but you'll rarely see error
numbers that high. Five thousand should be ample.

 

[storrboy]

I mentioned these two sources as they are somewhat different and
sometimes it can be hard to remember which list to look at - there are
some errors in the first topic that are not found in the table created
by the function like 3, 20, 91.... AccessError will display only those
it recognizes, the rest can be displayed by using the Error() function
(usually these errors are only found in VB).

 

[Dirk Goldgar]

I mentioned these two sources as they are somewhat different and
sometimes it can be hard to remember which list to look at - there are
some errors in the first topic that are not found in the table created
by the function like 3, 20, 91.... AccessError will display only those
it recognizes, the rest can be displayed by using the Error() function
(usually these errors are only found in VB).

True, I forgot about the VB errors. Unfortunately, a lot of information
was lost, or at least made impossible to find, in the transition from
the Access 97 help system to the Access 2000 help system. A lot of
people keep the A97 help file handy, even when they aren't using Access
97 any more.

 

[storrboy]

True, I forgot about the VB errors. Unfortunately, a lot of information
was lost, or at least made impossible to find, in the transition from
the Access 97 help system to the Access 2000 help system. A lot of
people keep the A97 help file handy, even when they aren't using Access
97 any more.

I'm one of them.
I was even considering copying pages from multiple help files and
making a custom one for myself. Not sure if I should though.
Infringing perhaps?

 

[Dirk Goldgar]

I'm one of them.
I was even considering copying pages from multiple help files and
making a custom one for myself. Not sure if I should though.
Infringing perhaps?

Probably not, unless you publish it. They *say* the help is much better
in A2007, at least if you accept the online content, and will be
improving as time goes on. I haven't installed that version yet,
though. Access 97 help was the best I've ever seen, for any software
product.