Hi:

I'm attempting to update a MSA 2003 DB that utilized the old Calendar control.  I'm referrencing this article: http://msdn.microsoft.com/en-us/library/gg251104.aspx , however when I try to follow the steps to use the steps descibed as "Use the Windows DatePicker control, part of the Windows Common Controls", I am stuck as the 'Microsoft DatePicker' control is not listed in the ActiveX controls.  I've added a reference to 'mscomctl.ocx' to my database... still nothing.

This is on a relatively new Win7 64 / Office 2010 installation.  I'm perplexed that something as simple as updating the calendar control on a form has taken 2+ hours of work / research and I'm still dead-in-the-water.

Bad job M$ on this one; it looks like many other users have had similar, but different, issues with the lack of a viable calendar control. Incredible that a $500 product can be so poorly executed in this regard.

Hi Jsoar,

There is a built-in DatePicker control.  When you click on a date field, you should see it appear to the right of the field.  You can just click on it and then choose your date.  I know this isn't the same as the calendar control as it is not always displayed.  An alternative would be to use a third-party control.  The following link has a couple of suggestions.

http://blogs.office.com/b/microsoft-access/archive/2010/01/09/access-2010-deprecated-features-and-components.aspx

I hope this helps!

Hi Sharon,

Thanks for your reply. In my case, the control is not bound to a data field - it is used with VBA procedures to navigate to different days to view and edit reservations. 

The article I referenced in my original post had some information regarding using the datepicker in this manner; i.e. when there's not a date field that the control is bound too.  But the control is not listed in my toolbox / activeX controls list.

I was venting a bit at the end, but my real technical question is more along the lines of: how can I get this date-time picker added so I can simply use that.  I have lots of places in several apps that utilize non-bound date controls, and I'd like to upgrade (my customers) applications.  But without this functionality, there's a real un-incentive (broken line-of-business apps) to do anything but keep running Access 2003 indefinately.

J.

Hi J,

The date and time picker control is part of the Windows Common controls.  The file is MSCOMCT2.OCX, located in C:\Windows\System32 on 32-bit or C:\Windows\Syswow64 on 64-bit.  If you don't have this file, you can download it from the following location:

http://activex.microsoft.com/controls/vb6/MSCOMCT2.cab

Once you download the file, you'll need to extract the files and then register the OCX file.  You will likely need to open the command prompt as administrator in order to get the file to register successfully.  Here are the steps in case you need them.

* Go to Start\All Programs\Accessories.
* Right-click Command Prompt and then click on Run As Administrator. 
* Change directory to the folder where you extracted the files.  For example, type the following and then press Enter:  cd c:\windows\system32
* Type the following and then press Enter:  regsvr32 mscomct2.ocx
* You should get a message saying this succeeded.

I hope this helps!

Hi Sharon,

This did not work at all. i downloaded MSCOMCT2.ocx. I copied it to C:\Windows\Syswow64 on 64-bit machine. I executed all the commands above as administrator. received a message saying registration was successful. I rebooted my machine. I went back into Excel and opened my sheet and went to VBA. I went to TOOLS => Aditional Controls and DatePicker was not listed. I went to TOOLS => References and looked for anything and found nothing. 

End result I still dont have a DatePicker control I can use.

I dont know what to do now and my whole application that used to work in XP is useless. 

Regards, Colin :(

• Proposed as answer by Bda75 Wednesday, September 19, 2012 1:54 PM
• Unproposed as answer by Bda75 Wednesday, September 19, 2012 1:54 PM
• Proposed as answer by Bda75 Wednesday, September 19, 2012 1:55 PM
• Unproposed as answer by Bda75 Wednesday, September 19, 2012 1:56 PM

Yes this worked. Although I had Office 2010 installed with a 6.1 version of this control. I don't know why I had to download and register a minor updated version to get it working.

You may not be looking at the right place. To find additional controls such as DatePicker control, go to the form controls window (Ex: Excel 2007: Developper tab + Insert + Form controls) and click on the "more controls..." icon. In the list displayed, you should be able to find "Microsoft Date and time picker control 6.0"

hope this may help.

• Proposed as answer by Bda75 Wednesday, September 19, 2012 2:01 PM

I have Office 2010 and followed the steps.

I cannot find "Microsoft Date and time picker control 6.0".

Any help would be greatly appreciated!

Thank you...  mckinziemadness

I think you can solve your problem using 32 bit version of ms office 2010

YuM

Hi Sharon, 

great answer. I used this date picker control in excel vba.

It worked okay.

However, I was wondering if there is a native built in date picker control that I can use in excel vba UserForms.

Because the excel .xlsm file could be used in different computers, it does not help to keep prompting the missing objects error message.

Thank you.

Worked like a charm for me - thanks! :)

(Windows Server 2008 R2, Microsoft Office 2010 32-bit)

Worked like a charm for me - thanks! :)

(Windows Server 2008 R2, Microsoft Office 2010 32-bit)

Dear Sharon,

I am having Excel 2007 in Windows 8 and I've tried with your instructions to fix MSCOMCT2.cab regitry but i got an error msg as follows."The Module"mscomct2.cab was located but the call to DllRegisterserver failed with error code ox8002801c. " How can I solved this case

Best Regards

Nalaka

I agree it's definitely horrible that there is no active x control on the 64 bit version, and I have searched for a long time to find some sort of form of datetimepicker I can use without having to bind the textbox to a date type control source. So I thought I'd post the solution I did find. Microsoft does have a builtin one that works for textboxes and bound controls.

But If you want a unbound datetimepicker..

You can take a standard textbox and set the "format" property to some sort of date format and the "Show Date Picker" property to "For dates", and it will show the drop down calendar type control on the right of your textbox when you click into it.

Have a great one!

Jeffrey

I also am experiencing issues with date picking when using forms generated under XP and now trying to run under Office 2010 (Win 8). This answer seems straightforward but how, when I insert a textbox into the form (where the previous datetimepicker box used to be), do I  set the "format" property to some sort of date format and the "Show Date Picker" property to "For dates", ?? 

neat! is it possible to do this in Excel? i tried and it didn't work. 

or, is it possible to use an Access control in Excel (without launching access).

thx!

I have searched everywhere for a solution for Excel 2010 & 2013 64 bit, and I have come to the conclusion that the 64 bit version cannot have access to the  Microsoft Date and Time Picker Control. I was told the same thing by a MrExcel MVP.

What worked for me, step-by-step for people as lost as I was

(1) I'm running Windows 7 (64-bit) and Excel 2010 (32-bit), rumor has it Excel 2010 (64-bit)
     simply doesn't have a solution.
(2) Download the Microsoft Windows Common Controls-2 6.0 from the Microsoft Web site:
     http://activex.microsoft.com/controls/vb6/MSCOMCT2.CAB
(3) Extract the file "MSCOMCT2.OCX" from the .CAB file to a folder "C:\Temp" say
     we need to copy this ocx file into the system folder
     "C:\Windows\sysWOW64" if you're running Windows 7 (64-bit) or
     "C:\Windows\System32" if you're running Windows (32-bit).
     So continue to the next step.
(4) Click the Start button and type "cmd" in the little search form at the bottom of the
      start menu where it says "Search Programs and Files".
(5) You should see "cmd.exe" highlighted at the top of the Program(s) list,
      Do a Right Mouse click on the icon and select "Run as Administrator"
(6) Now you'll have a command line opened,
      type "cd \Windows\sysWOW64" if you're using Windows 7 (64-bit) or    
      type "cd \Windows\system32" if you're using a 32-bit version of windows.
      Then press Enter.
(7) Next type the 2 commands in succession
      copy C:\Temp\mscomct2.ocx .  <Press ENTER>
      regsvr32 MSCOMCT2.OCX        <Press ENTER>
(8) You should see confirmation of success after each command.
     You should now be all set.

To access the control for use on your forms.

(1) Start Excel and press the keyboard keys <ALT> + <F11> to start Visual basic Editor
(2) Open the userform you plan to add the monthview control to.
(3) You should see the "Toolbox" panel pop up, if not, press the keyboard keys <ALT> + 'v' + 'x'
(4) Do a Right mouse click on any of the available controls and select "Additional Controls..."
     This should display the "Additional Controls" dialog box
(5) Scroll down and Look for "Microsoft Monthview Control 6.0 (SP6)" on the "Available Controls" list
(5) Select the tick box next to it and Click the [OK] button.
(7) You should see the Calendar icon of the "Monthview" control on return to the Toolbox panel

Had the same problem when moving from win7 64 bit & Access 2010 to win8.1 64 bit with Access 2010. Datepicker control was no more available.

I have downloaded mscomct2.cab, copied the mscomct2.ocx file to c:\windows\sysWOW64, registered it without errors, but it does not solved my problem.

What worked for me was starting c:\windows\sysWOW64\cmd.exe as an administrator and registering mscomct2.ocx from here, instead of using the system's shortcut to cmd, which point to c:\windows\system32\cmd.exe.

So, follow the step-by-step tutorial from above, but instead of

(4) Click the Start button and type "cmd" in the little search form at the bottom of the
      start menu where it says "Search Programs and Files".
(5) You should see "cmd.exe" highlighted at the top of the Program(s) list,
      Do a Right Mouse click on the icon and select "Run as Administrator"

follow

(4-5) Open Computer and navigate to C:\Windows\sysWOW64 folder. Right-click cmd.exe and choose "Run as Administrator"