Access Programming/VBA Question

[Rob]

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)

 

[Baz]

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

 

[Marshall Barton]

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)

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