PC Review


Reply
Thread Tools Rate Thread

Compile Error: Can't find project or library

 
 
Joe Wedel
Guest
Posts: n/a
 
      16th Jul 2003
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
 
Reply With Quote
 
 
 
 
JeffK
Guest
Posts: n/a
 
      16th Jul 2003
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
>.
>

 
Reply With Quote
 
 
 
 
Joe Wedel
Guest
Posts: n/a
 
      18th Jul 2003
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
>>.
>>

>.
>

 
Reply With Quote
 
New Member
Join Date: May 2010
Posts: 1
 
      20th May 2010
This had me stuck, VBA I thought I was done with you.

thanks for the help
 
Reply With Quote
 
New Member
Join Date: Oct 2007
Posts: 3
 
      6th Dec 2011
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.



Quote:
Originally Posted by Joe Wedel View Post
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
>>.
>>
>.
>
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compile error: Can't find project or library Daniel Microsoft Excel Programming 3 8th Dec 2004 02:05 PM
Date function gets compile error: Can't find project or library fredg Microsoft Access 1 27th May 2004 12:14 AM
Compile Error, Can'f Find Project or Library therrm Microsoft Excel Programming 1 25th Nov 2003 05:53 AM
Excel prob = Compile error cant find project or library David Microsoft Excel Misc 1 5th Sep 2003 10:38 AM
Compile Error! Can't find project or Library --- Help! Suh Suk Ho Microsoft Excel Programming 2 21st Jul 2003 08:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:20 AM.