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: 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! Source Link: Tony Chen TechNet Community Support. 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: 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!
Source Link: Tony Chen TechNet Community Support. I am trying to use the ActiveX datetime picker in a Win 64 environment, but using 32-bit Office as a way for users to set the date and time of an event.
My application uses Access 2010 front end and SQL Server back end. There is no end of discussions for how to do a date entry on the web, and little useful discussion about dealing with times. Through playing around, I am reasonably happy with the datetime picker from 'the past'. My instance in Access shows the class as MSComCtl2.DTPicker.2. What's missing for me is a help file.
When I use the Access properties window, place the cursor in a property value and press F1 to learn more about the property, I get the usual tired MS help screen that is nothing more than a regurgiation of the control name spelled out, or no help at all. If I use the custom properties dialog via the control context menu, and click the help button on that screen, I am told I'm missing the cmctl298.chm file in the WOW64 folder. I thought maybe this was an old '64-bit install doesn't register correctly' issue, but I've searched my hard drive, and there is no such file. I've done the Google, MSDN, and TechNet dances, but I am not having any luck finding this help file so far from a source I know and trust.
There are always places on the web that claim to have any file one looks for, but I won't install MS products from any source other than Microsoft. Been there, done that, been burned.
I have every version of Windows, Office, and VS that has ever been released. Can someone tell me where to find the help file or some detailed documentation for how this control works with Access (I've found.net docs, but the vast majority of the properties and methods discussed there I do not believe are exposed to the Access interface and the ones I am interested in leasrning more about are not in the documentation). Maybe I'm also barking up the wrong tree.
If there is a more modern control I should be using, I'm good with it, as long as I do not have to install anything at the system level on the client machines (there are thousands of them all over the world with centralized IT managed from another country, so I cannot add or subtract from the Windows installation, and cannot install updates to Windows or Office). Thanks in advance to anyone who has some direction for me on this one. This is crazy.
I'm a novice, All i want is a calendar box i can select a date from without manually inputting it. I have spent nearly 6 hours trying to get it to work. I have downloaded mscomct2 and put it in system32 and confirmed it had succeeded. On further advice, i have even put it in sysWOW because i have windows 8 64 bit. And it succeeded. No date time active controls available in 'developer - insert - more controls'. Isnt this a basic thing?
How can microsoft miss this? Why is it so difficult?? - can someone give me a basic simple solution.
Or a basic reason why you cant. Please remember i'm a novice. This is crazy. I'm a novice, All i want is a calendar box i can select a date from without manually inputting it. I have spent nearly 6 hours trying to get it to work.
I have downloaded mscomct2 and put it in system32 and confirmed it had succeeded. On further advice, i have even put it in sysWOW because i have windows 8 64 bit. And it succeeded. No date time active controls available in 'developer - insert - more controls'.
Isnt this a basic thing? How can microsoft miss this?
Why is it so difficult?? - can someone give me a basic simple solution. Or a basic reason why you cant. Please remember i'm a novice I would also like to know this as i'm currently not able to load date and time picker for userform. I have added the references, with MS common controls, but the control tools do not show calender to be added.
Ian Fife February 23, 2009 at 9:02 am I have developed a worksheet for my department and it includes the use of Microsoft Date and Time Picker Control 6.0 as part of a UserForm. When I distributed the worksheet, a few employees have had the debugger come up when the UserForm appears because their version of excel does not have the Microsoft Date and Time Picker as an option under 'Additional Controls' on the toolbox pulldown. I tried installing the Picker using your instructions above but all that happened was it ran a command box for a split second and then nothing happened. Any suggestions?
Mscomct2 Ocx Files
Some Microsoft Excel 2003 users have the control, others do not. Can the problem be resolved through a service pack download or some sort of Microsoft update? Or perhaps you may know what I am doing wrong when I tried running the above download. Any ideas would be appreciated!
Andrew June 11, 2011 at 4:55 am You're probably using a different version of Windows and/or Excel than the people on this forum. Archicad keyboard shortcuts pdf merge. 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.CAB file, unzip it and place the file 'MSCOMCT2.OCX' in the folder 'C:WindowssysWOW64' if you're running Windows 7 (64-bit) or place it in the folder 'C:WindowsSystem32' if you're running Windows (32-bit).
You'll get a prompt that you need to be an Administrator, accept all of that. (3) Click the Start-Menu, where it says 'Search Programs and Files' in the little search form at the bottom of the start menu, type 'cmd' right click on the icon and select 'Run as Administrator' (4) Now you'll have a command line opened, type 'cd WindowssysWOW64' if you're using Windows 7 (64-bit) or type 'cd Windowssystem32' if you're using a 32-bit version of windows. (5) type 'regsvr32 MSCOMCT2.OCX', press Enter.
(6) You should be all set just go back to Excel, click your Developer tab, click 'Insert' 'More Controls' (icon in the bottom right of the box) (7) Select 'Microsoft Date & Time Picker' out of the menu. Hopefully this helps someone.
Ian December 17, 2010 at 9:35 am Since my initial comment above well over a year ago I have had success registering the MSCOMCT2.OCX and installing the DT Picker Control on all our systems. However, as systems in our department are switching over to Windows 7 I am having a similar problem to 'Guest' where the control will not register. I am guessing it has to do with the enhanced safety features on Windows 7 and restrictions on being able to download content, even if logged in as the administrator. Anyone have a solution for this? Helen Feddema June 6, 2011 at 7:00 am I copied the MSCOMCT2.OCX file to the System32 folder (after getting an Access Denied message from the.bat file).
Mscomct2.cab Installieren
However, I still get the 'Could not load some objects because they are not available on this machine' error message when trying to install an Outlook UserForm that had a DateTimePicker control on it (this userform was created on another computer, which had — long ago — had the Developer Edition of Office 2000 on it, the original source of this control). So it appears that just copying the.ocx file isn't enough. What else is needed? Sami December 17, 2013 at 12:44 am Thanks Every one. Its works only on doing these below steps.
Download the MSCOMCT2.cab to desktop (reffer the first link “download it here”) 2. Install 7zip.
Extract the MSCOMCT2.cab file on the desktop. You get two files “mscomct2.bat” and MSCOMCT2.OCX. Copy MSCOMCT2.OCX to c: windows system32 (if the file is already there rename the old file to MSCOMCTold.OCX) and then try again. Run the mscomct2.bat (Please use run ad administrator even if you have admin rights) Now see the magic works fine. I was trying this solution for a month and finally i got it from this site. Thanks every one.
Paul February 4, 2014 at 12:43 pm I combined John Remmes’ information with this and for me running Office 2007 on a Windows 64bit machine, this was my solution to add the Picker Control: Download and unzip the.bat and.ocx files. Place them into the C: Windows System32 folder Click on the Developer button. Click on Insert.
Click on the More Controls icon. Click on Register Custom.
This will default to the System32 folder. Double click on the MSCOMCT2.OCX file. The Microsoft Date and Time Picker Control will now appear in the list. MSP Computer Maintenance June 25, 2017 at 7:15 am Daniel, I had already installed the Microsoft Date and Time picker and every time I would close out of the excel document and re-open it the picker would disappear and just a blank spot was there. I would then have to go into design mode, delete it, recreate it and then link the cell again. I had to explain this procedure and set it up for the vendors as well.
It was driving me nuts. I started looked into this and discovered your installation procedure. I ran the files and fantastic, I no longer have a blank cell but I have an oversized calendar showing up. Now, the calendar still doesn’t work but I discovered that if I zoom out and back in by holding the CTRL key down and scrolling up and down on the middle mouse button that the calendar works So THANK YOU THANK YOU THANK YOU!! Wayne Leiser, I.T.
Director B2B I.T. Solutions (941) 923-6280 M – F: 9am – 5pm EST.