Access 2000 form with Access 2002 and 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top