can not display DTPicker calendar GUI

[James]

Dear all, I had a problem with the Access2003 database. Users use an access
database in a server's share folder in the LAN. When double click a form in
the database, it will popup a window which allows users to choose the date.
But there is a new computer can not display DTPicker calendar GUI. It just
displays a blank area instead which is like in the edit mode. All other
computers are fine except this one. All computers are using WindowsXP SP2. I
already checked the date format on the new computer which is the same as on
other computers. It is very strange. Are there some Control components
support DTPicker missing in the new computer? Any thoughts? Hope you can help
me. Thanks.

 

[ruralguy via AccessMonster.com]

Have you checked for bogus MISSING references? I would pick a calendar from
Jeff's links. Almost all do not use the ActiveX calendar so no versioning
problems.
http://home.bendbroadband.com/conradsystems/accessjunkie/calendars.html

 

[James]

ruralguy. Thank you for your help.
I checked the Access database uses Calendar Control 11.0 which is also used
in the new computer. When I double click the form from the database window,
it popup a error message :"There is no object in this control". Do you know
what the problem is?

 

[J. Goddard]

The calendar control is not in the references. Open any code module,
then go to Tools - References. The calendar control is not likely
checked off (all are at the top of the list). Scroll through the list
of available references to see if you find it - if you do, select the
reference, re-compile and save. That should work.

If it is not is the list, all is not lost - if you know the name of file
for the control (probably an .ocx), you can set up the reference to it
by browsing for and selecting the file. Maybe the one computer giving
you the trouble doesn't have that file on it.

This is a common problem (in my environment) with new installs of MS Access.

John

 

[James]

Thank you for your help.
The problem has been fixed. There is one ActiveX component missing from the
new computer - Microsoft Date and Time Picker Control 6.0 (sp4). I copied it
from other computer to the new computer. It is working fine now.
Thanks.

 

[James]

Thank you, John.
It's been fixed. Just like you said. Thanks.