Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Edinburgh, Midlothian, Scotland
    Posts
    492
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error codes (Access XP)

    While writing something this morning, I got the familiar

    Run-time error XXXX

    I solved the problem, but the error message is about as much use as a chocolate teapot. Is there a central list of these codes which can be downloaded, so that it is easier to debug in the future?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Error codes (Access XP)

    I don't know of a complete and really useful overview, but here are some tips:

    - Activate the Visual Basic Editor (Alt+F11)
    - Activate the Immediate window (Ctrl+G)
    - Type OpenForm and press F1.
    - This opens the online help with the relevant bits available (long live HTML help - NOT)

    - Type trappable in the Answer Wizard tab of the help window and press OK.
    - The Trappable Errors subject lists generic VBA error numbers. Click on an error for more info.

    - Type number error in the Answer Wizard and press OK.
    - Select Number Property (DAO), then click Trappable Microsoft Jet Errors.
    - This lists DAO errors. Click on an error for more info.

    - Type ADO error in the Answer Wizard and click OK.
    - The ErrorValueNum subject lists ADO errors.

    The attached database contains an empty table. If you run the procedure FillErrorTable in the basErrors module, the table will be populated with a list of error numbers and the accompanying error message.
    Attached Files Attached Files

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Edinburgh, Midlothian, Scotland
    Posts
    492
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error codes (Access XP)

    Great

    I think i'll need an hour or so to look at that. I'll try over the weekend.

    Thanks

    Colin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •