p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Expert One-on-One Access Application Development (http://p2p.wrox.com/forumdisplay.php?f=131)
-   -   LNC Rename control Add-in error (http://p2p.wrox.com/showthread.php?t=14301)

jbage June 16th, 2004 12:32 PM

LNC Rename control Add-in error
 
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

Bob Hansen June 16th, 2004 01:09 PM

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

jbage June 18th, 2004 02:08 PM

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

HelenFeddema July 8th, 2004 07:24 PM

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/

rpfister51 April 29th, 2005 04:12 PM

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.

larryh16 June 1st, 2006 01:43 AM

Quote:

quote:Originally posted by HelenFeddema
 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/


jonny10 November 30th, 2006 06:46 AM

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 :)


mornao99 March 22nd, 2007 08:41 AM

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.



All times are GMT -4. The time now is 05:23 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.