run-time error: need to look up the number and it's definition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:

How does one look up the number associated with a run-time error.

Is there a table out there somewhere that I can go to.

How does one get to it in VB editor?

Thanks
pepe
 
Hi, Pepe.
How does one look up the number associated with a run-time error.

Is there a table out there somewhere that I can go to.

One may create the Access and Jet Errors table as a personal reference.
Please see the tip, "How to create a listing of the Access and Jet errors" on
the following Web page for the VBA code needed:

http://www.Access.QBuilt.com/html/vba.html
How does one get to it in VB editor?

It's not a built-in option, so one must open the table that's created from
the code in the tip to read the relevant information. One may also get the
error description of the error when the error number is known by using the
Immediate window. Please see the tip, "How to get the Error Description from
the Error Number" on the same Web page.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question, please sign in to Microsoft's
Online Community and mark these posts, so that all may benefit by filtering
 
You're welcome. And thanks for marking my post as an answer. It's greatly
appreciated!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts, so that all
may benefit by filtering on "Answered questions" and quickly finding the
right answers to similar questions. Remember that the best answers are often
given to those who have a history of rewarding the contributors who have
taken the time to answer questions correctly.
 
Back
Top