Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    compile error on Mid and Right (XP)

    I've seen this happen before but never worked out why, when I compile I get a compile error: Can't Find project library. the offending functions are 'Right' and 'Mid'.
    any idea on why or how to overcome this?

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: compile error on Mid and Right (XP)

    Usually this is a problem with References. For me it happens when I install a db on a different computer with a different version of Access or other windows components.

    <UL><LI>Open the db with the shift key down.
    <LI>Press Alt + F11 to activate the VBA Editor
    <LI>Go to Tools References.
    <LI> Some of the ticket references will show the word missing. Untick them.
    <LI> in the list of available libraries look for a replacement for the ones you have unticked. Tick them . Usually the same item will be listed, but with a different version number[/list]Close and reopen the db.
    Regards
    John



  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: compile error on Mid and Right (XP)

    That is certainly the cause but Access won't let me fix it. "Can't perform requested operation."
    I should be able to copy all the objects to a new container with the correct references to fix it.
    So ... Thanks again Hans

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

    Re: compile error on Mid and Right (XP)

    Er, John Hutchison was the one who helped you...

  5. #5
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: compile error on Mid and Right (XP)

    Thanks John
    Regards

Posting Permissions

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