dtpicker field blank

[blees10]

Hey Guys,

I have an issue with a dtpicker field in one of my forms. I developed this form using Access 2003 and everything works fine. Recently, I've been asked to deploy this database to secondary office. The version of Access loaded on each workstation in the seconday office is Acces 2003 as well.

The Active X control for the dtpicker in my development copy is Microsoft Date and Time Picker Control 6.0 (SP4). The version of this control in the secondary office is SP6. So I know this is probably where the issue lies in.

When I implemented the database, the users in the secondary office did not have a problem. They can see the date field and select the appropriate dates. The issue occurs when I compact and repair the database on their local server. The compact and repair seems to wipe out that control or field and the form is left with a blank area where the date field used to be.

Does anyone know how to get the right version of this control and how to register etc.?

Thanks!

[puppydogbuddy]

SP6 is a later version, but you should be able to use your version provided it is registered on each machine that is having a problem.
Try to register it, try:

regsvr32 "C:\Windows\System\mscomct2.ocx"

to avoid problems like this, I recommend you not use an activeX. Instead, use a calendar control created from a native ms access form. See below.
http://allenbrowne.com/ser-51.html
http://www.mvps.org/access/forms/frm0057.htm

[pepevr]

blees10,

Did you figure out what the problem was?. I am having the same issue. I also have control version SP6. I have tried to register it also, but I am still having the problem.

Thanks,