Compile Error: Can't find project or library

Discussion in 'Microsoft Access VBA Modules' started by Joe Wedel, Jul 16, 2003.

  1. Joe Wedel

    Joe Wedel Guest

    I wrote an Access program that works fine on my
    development machine, but has a compile error on the client
    with the UCase function at the following code:

    Private Sub Form_Current()
    If UCase(Live) = "Y" Then
    ynLive = True
    ynLive = False
    End If
    End Sub

    The error is:
    Microsoft Visual Basic
    Compile error:
    Can't find project or library

    I look in Object Browser on the client, and UCase shows as
    a member of VBA.Strings. I have verified that the
    VBE6.DLL is in the correct directory. Any ideas why this
    error is happening?

    Joe Wedel, Jul 16, 2003
    1. Advertisements

  2. Joe Wedel

    JeffK Guest

    This happens whenever any of the references cannot be
    found. It just misleadingly displays an error on a
    function from the first library in the list (VB) when it
    is missing any one of the libraries. On the other
    machine, go into the VBE and select Tools | References
    from the menu bar. Fund the one marked MISSING, remove it
    and browse to find the correct one.
    JeffK, Jul 16, 2003
    1. Advertisements

  3. Joe Wedel

    Joe Wedel Guest

    Thanks JeffK, you nailed it.
    Joe Wedel, Jul 18, 2003
  4. Joe Wedel


    May 20, 2010
    Likes Received:
    This had me stuck, VBA I thought I was done with you.

    thanks for the help
    wiskers69, May 20, 2010
  5. Joe Wedel


    Oct 9, 2007
    Likes Received:
    This is the case usually for me, and the fix. Imagine my surprise when this recently happened in my MS Outlook VBAProject.OTM file and *there are no missing references* shown in the references dialog box.

    Now I can't figure out what the problem is!! I started deleting all the code but then I realized this is not going to help much either.

    mrbillbenson, Dec 6, 2011
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.