vba on Access 2002

plgii

Registered User.
Local time
Today, 12:07
Joined
Apr 13, 2006
Messages
15
I wrote code on Access 2003 and the default db is set to 2000, but when code is run on Access 2002, lots of errors and certain elements won't work. Is there that much difference between these VBA versions? If so, how can I correct this so users can run program on 2002?
 
It could be various things, possibly references.

It would be a good idea to post your code!
 
too much code to post, but I do know that the 2002 machine is running 10.0 Object Library and I am running 11.0 Object Library. Also on the help & About Visual Basic the 2002 version has Form3:11.0.5709 and mine has 11.0.6550.

When you try to go into the design view on the 2002 version, it pops up all kinds of vba windows and errors.
One example code is:
Me!lblClock.Caption = Format(Now, "dddd, mmm d yyyy, hh:mm:ss")
on the timer event to place date and time on form...it does not show up.

If the references are the issue, then is there a way to update theirs without upgrading to access 03? or is it just easier for them the bite the bullet and move up?
 
Have you tried moving all your objects in to a new db?
 
I would guess you mean on the 2002 machine... and not to look stupid, but don't think I have ever done it...can you clue me in on it?
I have imported one db to another, but don't think that is the same.
 

Users who are viewing this thread

Back
Top Bottom