Compile Error: Can't find project or library

[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

 

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

 

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

.

 

[wiskers69]

This had me stuck, VBA I thought I was done with you.

thanks for the help

 

[mrbillbenson]

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