?
Solved

Can't find project or library. How do I fix this?

Posted on 2004-10-15
5
Medium Priority
?
276 Views
Last Modified: 2010-08-05
Hello all,

I'm trying to use the MDB database made on one PC at another PC. Access is 97 on both PCs. However, when the script reaches the lines:

Private Sub ProdRunCombo_Change()
    If Trim(Left(Me.ProdRunCombo, 1)) = 0 Then
        Me.StartField.Enabled = False

an error 'Can't find project or library' appears, and the word 'Left' is highlighted. I assume that the 'Left()' function is not defined in target Access for some reason - I can't view Help on it, although it is listed in Objects list there.

How can this be fixed? Re-link some reference?

P.S. When I compile an MDE at my PC, everything works OK there - but I need an MDB to work.
0
Comment
Question by:Yaroslav_Buzko
3 Comments
 
LVL 3

Accepted Solution

by:
StuartSanders earned 172 total points
ID: 12317431
In a code window, got to tools > references.

Note down the exact versions that appear checked on both your machine and at the other machine.  Chances are one of them is slightly different.  Maybe Microsoft DAO 3.5 and 3.51.

Also make sure that both machines are running Access/Office with the same service pack level.  Its been a while but I think SR2b was the last for office 97.

if that doesn't give you any satisfaction, please give me the list of references that are selected.

Stuart
0
 
LVL 44

Assisted Solution

by:Arthur_Wood
Arthur_Wood earned 164 total points
ID: 12317867
in addition to what StuartSanders has said, also check, under Tools/References for aANY reference marked as MISSING.

If there are 'Missing' References, make a note of which one(s), then UNCHECK the MISSING reference, and click on the OK button.  Then re-open Tools/References and re-select the previous MISSING reference - the list is alphabeticval, and you will need to scrool down the list to re-locate the previously MISSING reference.  Select it (so the Check box is CHECKED) then click the OK button again.  That should resolve the problem.

AW
0
 
LVL 51

Assisted Solution

by:Steve Bink
Steve Bink earned 164 total points
ID: 12322660
The library you are having difficulty with is the standard "Visual Basic for Applications" library.  In my installation with Office 2002/XP, the filename you will be looking for is VBE6.DLL, and is located by default in "C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6".  Since you are using Access 97, your version may be different...You will have to look at the References to get the actual filename.

You can search your drive for the file and use REGSVR32 to register it again, if necessary.  Otherwise, just copy the file from your working PC to the non-working PC, then use the Reference dialog to point Access to the right place.

As a side-question, did you install 2 different versions of Access on the 'bad' PC?  Or even upgrade from a previous version of Access on that computer?
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question