 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / January 2007Access Programming/VBA Question
First, let me preface by saying that I do know Access 97 is severly outdated. My client is just now switching their main accounting application from a DOS based to Windows based, and Access too will be upgraded. The machines in question all have Windows XP Pro, Access 97. I have coded changes on one machine and got them working properly. I copy the database over to two other machines. When I attempt to run, I get one error that says "COmpile error in hidden module: zasDevelopment" (zasDevelopment may be unique to the application. I get another error that isn't recognizing VB formatting functions (like Mid). When I run the exact same database on my machine it works. When I run a pre-change copy of the database on the two new machines, things work. It's only when I attempt to run my changes that I get the error. Any ideas? (Besides upgrade Access) On the machines where it doesn't work, have you checked the References window (in the Code window, Tools menu-->References). Most likely something will be showing as "Missing". Don't upgrade, Access 97 is just fine (Access 2000, 2002 and 2003 are really just Access 97 with a paint job). > First, let me preface by saying that I do know Access 97 is severly outdated. > My client is just now switching their main accounting application from a DOS [quoted text clipped - 9 lines] > > Any ideas? (Besides upgrade Access) >First, let me preface by saying that I do know Access 97 is severly outdated. > My client is just now switching their main accounting application from a DOS [quoted text clipped - 9 lines] > >Any ideas? (Besides upgrade Access) Check the References on the other machines (VBA window - Tools - References). They are probably missing a library or possibly have the wrong version of the right library. http://www.accessmvp.com/djsteele/AccessReferenceErrors.html While you're in there double check your machine's copy of the database to make sure you are not referencing any libraries unnecessarily. http://www.granite.ab.ca/access/referencetroubles.htm  SignatureMarsh MVP [MS Access] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.