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

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

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

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

Originally Posted by 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.
>
>>-----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
>>.
>>
>.
>