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
    Else
    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?

    Thanks!
    -Joe
     
    Joe Wedel, Jul 16, 2003
    #1
    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
    #2
    1. Advertisements

  3. Joe Wedel

    Joe Wedel Guest

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

    wiskers69

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

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

    mrbillbenson

    Joined:
    Oct 9, 2007
    Likes Received:
    0
    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
    #5
    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.