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.

    >-----Original Message-----
    >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
    >.
    >
     
    JeffK, Jul 16, 2003
    #2
    1. Advertisements

  3. Joe Wedel

    Joe Wedel Guest

    Thanks JeffK, you nailed it.
    -Joe

    >-----Original Message-----
    >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.
    >
    >>-----Original Message-----
    >>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 18, 2003
    #3
  4. Joe Wedel

    wiskers69

    Joined:
    May 20, 2010
    Messages:
    1
    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
    Messages:
    3
    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

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Laura

    consistent "can't find project or library" error

    Laura, Mar 30, 2004, in forum: Microsoft Access VBA Modules
    Replies:
    1
    Views:
    187
    Douglas J. Steele
    Mar 31, 2004
  2. Guest

    "Compile error...Can't find project or library"

    Guest, Apr 18, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    4
    Views:
    401
    Alex Dybenko
    Apr 18, 2005
  3. Guest

    Compile Error: Can't find project or library

    Guest, May 9, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    2
    Views:
    277
    Guest
    May 10, 2005
  4. peejay

    compile error cites Error function for missing library

    peejay, Feb 6, 2007, in forum: Microsoft Access VBA Modules
    Replies:
    2
    Views:
    179
    Douglas J. Steele
    Feb 6, 2007
  5. Guest

    Compile error: Can't find project or library

    Guest, Jul 12, 2007, in forum: Microsoft Access VBA Modules
    Replies:
    1
    Views:
    254
    Guest
    Jul 12, 2007
Loading...

Share This Page