PC Review
Forums
Newsgroups
Microsoft Access
Microsoft Access VBA Modules
Compile Error: Can't find project or library
Forums
Newsgroups
Microsoft Access
Microsoft Access VBA Modules
Compile Error: Can't find project or library
![]() |
Compile Error: Can't find project or library |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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 |
|
|
|
#2 |
|
Guest
Posts: n/a
|
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 >. > |
|
|
|
#3 |
|
Guest
Posts: n/a
|
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 >>. >> >. > |
|
|
|
#4 |
|
New Member
|
This had me stuck, VBA I thought I was done with you.
thanks for the help |
|
|
|
![]() |
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

