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

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.
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:
    415
    Douglas J. Steele
    Mar 31, 2004
  2. Laura

    Re: consistent "can't find project or library" error

    Laura, Apr 1, 2004, in forum: Microsoft Access VBA Modules
    Replies:
    1
    Views:
    310
    Douglas J. Steele
    Apr 1, 2004
  3. Andy

    Complie error: Can't find project or library

    Andy, May 12, 2004, in forum: Microsoft Access VBA Modules
    Replies:
    2
    Views:
    427
  4. Guest

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

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

    Compile Error: Can't find project or library

    Guest, May 9, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    2
    Views:
    482
    Guest
    May 10, 2005
  6. Guest

    Can't find Project or Library error

    Guest, Jun 16, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    2
    Views:
    337
    Guest
    Jun 17, 2005
  7. Guest

    Can't find Project or Library error

    Guest, Jun 16, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    0
    Views:
    263
    Guest
    Jun 16, 2005
  8. Guest

    Compile error: Can't find project or library

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