none
Access 2010 Datepicker control missing RRS feed

  • Question

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

    Tuesday, March 1, 2011 5:44 PM

Answers

  • 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!


    Sharon M, Microsoft Online Community Support
    • Proposed as answer by Harry Yuan Thursday, March 10, 2011 3:35 AM
    • Marked as answer by Harry Yuan Monday, March 14, 2011 1:55 AM
    Wednesday, March 9, 2011 3:01 PM

All replies

  • 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!


    Sharon M, Microsoft Online Community Support
    Friday, March 4, 2011 6:15 PM
  • 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.

    Tuesday, March 8, 2011 2:27 AM
  • 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!


    Sharon M, Microsoft Online Community Support
    • Proposed as answer by Harry Yuan Thursday, March 10, 2011 3:35 AM
    • Marked as answer by Harry Yuan Monday, March 14, 2011 1:55 AM
    Wednesday, March 9, 2011 3:01 PM
  • 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 :(

    Friday, August 31, 2012 7:43 AM
  • 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.
    Thursday, September 13, 2012 12:19 PM
  • 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.

    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

    Tuesday, November 6, 2012 12:04 AM
  • I think you can solve your problem using 32 bit version of ms office 2010

    YuM

    Thursday, November 15, 2012 7:03 PM
  • 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.

    Sunday, November 25, 2012 8:12 AM
  • Worked like a charm for me - thanks! :)

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

    Monday, July 1, 2013 8:45 AM
  • 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

    Thursday, August 1, 2013 3:34 AM
  • 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


    Programmer in vb6 & .net

    Monday, May 12, 2014 6:09 PM
  • 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", ?? 
    Sunday, May 18, 2014 4:24 AM
  • 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!

    Friday, June 6, 2014 3:24 AM
  • 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.
    Tuesday, July 1, 2014 8:37 AM
  • 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

    Thursday, July 3, 2014 10:33 AM
  • 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"

    Tuesday, March 10, 2015 11:41 AM
  • Access Denied

    You don't have permission to access "http://activex.microsoft.com/controls/vb6/MSCOMCT2.cab" on this server.

    Reference #18.b652e953.1453549203.5d55bbc

    Saturday, January 23, 2016 11:41 AM
  • I have done the steps but date picker still not in selection. after custom register of file MSCOMCT2.OCX I got an error message "the selected file does not contain self registering activex control
    Thursday, September 1, 2016 6:26 AM
  • This worked for me! Thanks!!
    Monday, December 12, 2016 12:31 AM
  • I decided to simply make a calendar control similar (but better) than the Access 2003 ocx calendar control, by only using VBA to make it weave tighter into my apps. The calendar is part of its own form, so to use it just add your objects around it.

    What I did was to use an option group and use the DateAdd, DateSerial, Weekday, Month, and Year functions. It works beautifully and I offer it up to those still having problems with other calendar controls.

    I would have posted here earlier, but I only recently dove into Access 365 due to the deprecated problems s.a. this. Also, my son, who works at MS gave Office 365 as a Christmas gift! Happily, everything works now- took a lot of programming but only a month to port over my Office 2003 app but I haven't looked back.

    URL for calendar control:

    https://1drv.ms/u/s!Am9xB7i5mNRohJJy5iJyNx5B0q27lw

    Enjoy!

    Regards,

    Al



    • Proposed as answer by Al Borges Wednesday, March 7, 2018 10:09 AM
    • Edited by Al Borges Wednesday, March 7, 2018 10:21 AM Added pic of calendar form in use...
    Wednesday, March 7, 2018 10:05 AM
  • Wow, thanks you for the ingenuity.

    However since it is in MS Access form, please kindly help me with the steps to incorporate it in spread sheets.

    Thank you.

    Thursday, April 19, 2018 6:39 AM