Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"Cannot find project or library" Message

Status
Not open for further replies.

barsa

MIS
Dec 20, 1999
11
US
I have a database out on a shared drive, and the problem that is occuring is that one user, upon using a form that performs a function, gets a &quot;Cannot find project or library&quot; error message and within the function in the VBA module the &quot;Date&quot; function is highlighted.&nbsp;&nbsp;This error does not happen on my machine, so why would this user not be able to perform the Date function that retrieves today's date?<br>She has the &quot;Visual Basic for Applications&quot; checked off in her References, where the Date is stated to reside....<br>What can be the problem??<br><br>Please help.
 
Could the problem machine have a less complete installation of Access running on it?&nbsp;&nbsp;If so, you can add additional &quot;advanced&quot; components from the installation CD.<br>Does the problem machine reference the same VBA file as the good machine?&nbsp;&nbsp;There are several different VBA files that all show up in the references list as &quot;Visual Basic for Applications&quot;, so I think the one that should be referenced is &quot;vba332.dll&quot;.<br><br>
 
this issue usually happens when a computer has a newer type library<br>you need to refresh your references<br><br>1 on the modules tab click new<br>2 on tools click references<br>3 in the references dialog box pick any one reference not already selected. note which one you selected then click ok<br>4 on tools click references again<br>5 clear the reference you selected in step 3 <br>hope that was it<br>
 
I have came across this problem before, usually the DAO have the word &quot;MISSING&quot; on the reference list.&nbsp;&nbsp;There is a web site that had a program the would fix that, if you want I can search to find that site.<br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top