469,127 Members | 1,327 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,127 developers. It's quick & easy.

dtpicker field blank

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!
Dec 4 '07 #1
2 2493
puppydogbuddy
1,923 Expert 1GB
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
Dec 9 '07 #2
pepevr
1
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,
Aug 3 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Janaka Wijayakoon | last post: by
5 posts views Thread by Robi | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.