472,796 Members | 1,767 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,796 software developers and data experts.

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.?

Dec 4 '07 #1
2 2643
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.
Dec 9 '07 #2

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.

Aug 3 '12 #3

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

Similar topics

by: someone | last post by:
Hi, We are encountering a problem with the DTPicker. This is the situation: We have a DTPicker-control on a VB6 Active-X. The Active-X is used on a .NET winform. the problem: The .Net...
by: Andreas Belitz | last post by:
Hello, in my project, i use a form with Microsoft's Dte Picker Control (MSComCtl2.DTPicker.2). This control is linked up to a date field of a table. When i open the form, the control always...
by: Janaka Wijayakoon | last post by:
Hi Everyone, I have added a DTPicker control to my web form. Its working fine with all the work station where that control is registered (Computers where vb runtime is installed) and dipayls a...
by: Killer42 | last post by:
Hi all. Short version: DtPicker goes strange when .Enabled changed in VBA code, looking for solution or good workaround. Looooong version: Those of you who have been following various threads...
by: siyoyok007 | last post by:
Hello, I'm developing simple system, that needs the use of DTPicker. For my system, i have placed two dtpicker, which means DTPicker1 and DTPicker2. The DTPicker1 will be used as starting date and...
by: psuaudi | last post by:
I have a form that I was creating and I wanted to use the microsoft date and time picker. in the On_Load event for the form, I want to set the date and time picker value to Now() Private...
by: Sid666 | last post by:
Hi, everyone I'm building an Access DB system using VBA. I have a ActiveX DTPicker so the user can select a date. This date is put in another textbox that is bound to a table. I do this because...
by: Robi | last post by:
I have a form which has a dtPicker control with a checkbox. The user checks or unchecks the box to indicate whether or not the date should be utilized. My problem is that the user would prefer to...
by: venkatanarasimhaa | last post by:
Hi, I am developing a simple application in VB. I have one DTPicker on my form. If the value of DTPicker is not mindate of DTPicker, It should not be allow us to enter any value earlier than...
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: Mushico | last post by:
How to calculate date of retirement from date of birth
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.