Access 2000 form with Access 2002 and 2003

[Guest]

I created a form in A2000 that has a calendar and Date( ).

The form works just fine on the machine where the mdb was created and on a
machine with A2003. But it fails on two A2002 machines where I want the app
to live. The calendar Active X component has to be removed and the date
function causes an error. I tried changing the references to different
libraries and registering the components.

Was there a MDAC or other component released after January 2003 that needs
to be dowloaded and installed?

Thx.

 

[Allen Browne]

The calendar ActiveX control usually breaks when you move version. Like any
bad reference, it prevents any code from running, or even basic function
such as Trim() or Date() from working.

The best solution is to dump the ActiveX calendar, and use a simple Access
form in its place. There's heaps of them around, e.g.:
http://allenbrowne.com/ser-51.html

For more info on handling and fixing reference issues, see:
http://allenbrowne.com/ser-38.html

 

[Guest]

Thank you sir. It was really strange that app worked in 2000 and 2003 but
not 2002.