Results 1 to 6 of 6

Thread: Error$

  1. #1
    Join Date
    Jan 2004
    Location
    Walnut Cove, NC
    Posts
    101

    Unanswered: Error$

    I have converted an Access 95 database to Access 2000. When I open the database in Access 2003, It always stops with the following:

    Compile Error
    Can't find project or library and it always has ERROR$ hilighted. The code looks like this:

    Err_MainMenu_Click:
    MsgBox Error$
    Resume Exit_MainMenu_Click

    The application is full of Error$. I believe it was in the library file utility.mda and I assume that was a part of Access 95????

    Is there an equivalent in Access 2000 for Error$ that I can just do a Find and Replace? I don't want to have to load utility.mda on every pc that uses this application.

    Thanks,

    Sherry

  2. #2
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    Err.Description should do same job with error$
    ghozy.

  3. #3
    Join Date
    Dec 2003
    Posts
    268

    Try this

    Replace Error$ with Err.number & ": " & err.description

    I think this is what you are looking for.

  4. #4
    Join Date
    Jan 2004
    Location
    Walnut Cove, NC
    Posts
    101

    Error$

    Thanks for both of your suggestions....I will try them this evening and let you know tomorrow.

    Sherry

  5. #5
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    mjweyland's solution gives more info than mine.
    ghozy.

  6. #6
    Join Date
    Jan 2004
    Location
    Walnut Cove, NC
    Posts
    101

    Error$

    Thanks to both of you. The err.description and Err.number & ": " & err.description both worked.

    Have a great day!!!!

    Sherry

Posting Permissions

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