Compile Error: Can't find project or library


J

Joe Wedel

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
 
Ad

Advertisements

J

JeffK

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

Joe Wedel

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.

.
 
Ad

Advertisements

Joined
Oct 9, 2007
Messages
3
Reaction score
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.



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

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. After that, you can post your question and our members will help you out.

Ask a Question

Top