PC Review Forums Newsgroups Microsoft Access Microsoft Access VBA Modules Compile Error: Can't find project or library



Reply

Compile Error: Can't find project or library

 
Thread Tools Rate Thread
Old 16-07-2003, 06:36 PM   #1
Joe Wedel
Guest
 
Posts: n/a
Default Compile Error: Can't find project or library

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
Old 16-07-2003, 10:14 PM   #2
JeffK
Guest
 
Posts: n/a
Default Compile Error: Can't find project or library

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
Old 18-07-2003, 09:29 PM   #3
Joe Wedel
Guest
 
Posts: n/a
Default Compile Error: Can't find project or library

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
Old 20-05-2010, 02:37 AM   #4
wiskers69
New Member
 
Join Date: May 2010
Posts: 1
Trader Rating: (0)
Default

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

thanks for the help
wiskers69 is offline   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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off