I think this is the same problem Sue posted earlier but I am having it using Access 2003 on Windows XP Pro. I am in Chapter 2 trying to use the LNC rename add-in. When I run it, I get "compile error: can't find project or library". When I click OK, the word LEFT is highlighted in the debugger. Sorry, but since I am kinda new to VBA, I can't be much more help than that.

I read the other posts and they seem to point to a missing file. Any ideas anyone?

Jim B

My thoughts were already submitted on 6/5/04 in response to a similar question. Can be found at: http://p2p.wrox.com/topic.asp?TOPIC_ID=14277

Thanks for the quick reply. I did check for the presence of the file mentioned and it is in my SYSTEM32 directory. I also ran through the steps of the other entry to no avail.

Thanks again for trying.

Jim

Jim B

This misleading error message generally results from a missing (or wrong version) reference. Check your references in the Tools|References dialog, and see if any are marked "MISSING". If so, uncheck them and check the version of that library on your computer.

Also, note that you need the Replace library (Find and Replace). A trial version of this add-in is included in the zip file.

Helen Feddema
Kerhonkson, NY
hfeddema@hvc.rr.com
http://www.helenfeddema.com
Read Woody's Access Watch
http://www.woodyswatch.com/waw/

I also had the error message "Can't find project or library" when trying to run LNC. "Chr$" was highlighted. I commented out the Chr$ part of command, then Mid$ and, finally, Left were highlighted. I checked references, none were marked MISSING.

On a hunch (from suggestions on handling similar errors elsewhere) I qualified the Chr$, Mid$, and Left references with "VBA." So, "Chr$" became "VBA.Chr$", etc. LNC then ran fine.

I have a same problem. How I make it automatically to ensure that it will run on other computer.

Can't tell to my end customer to look under Tools -> References :)

Have read the postings above, but the way I resolved the 'Missing project' error is to RTM.

Extract the LNC whole zip file into your 'c:\temp' directory, then execute Repl9.exe which places 3 components into your My Documents directory, then manually place the LNC mda object into Addins. Perform the AddIn manager action and it works.

Try running the Repl9.exe if you encounter the error.