Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTPicker control missing (Win XP/Excel 2007)
I know this is a common problem, but I have been
unable to find a solution that matches my system. I'm using Windows XP (Service Pack 3) and Excel 2007 (Professional Edition). The problem is that the Microsoft Date and Time Picker Control (DTPicker) is missing from my form controls toolbox. I tried searching in the "Additional Controls..." dialog box, but I found nothing. Anyone know how to fix this or reload the DTPicker control? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTPicker control missing (Win XP/Excel 2007)
I know this is a common problem, but I have been
unable to find a solution that matches my system. I'm using Windows XP (Service Pack 3) and Excel 2007 (Professional Edition). The problem is that the Microsoft Date and Time Picker Control (DTPicker) is missing from my form controls toolbox. I tried searching in the "Additional Controls..." dialog box, but I found nothing. Anyone know how to fix this or reload the DTPicker control? Thanks! Would this be the MSCOMCT2.OCX that's listed as *Microsoft Date and Time Oicker Control 6.0*, and located in the Windows\System32 folder? The version I have is SP6 because it was updated when I install VS6 SP6, but yours might be a different version if it wasn't updated when you installed Office12. Note that dispite it's descriptive name it doesn't have any visible time picking features, just a dropdown arrow to display its calendar. Another control I found listed is Calendar Control 12.0 (MSCAL.OCX) located in the Office11 folder. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTPicker control missing (Win XP/Excel 2007)
Typo...
Would this be the MSCOMCT2.OCX that's listed as *Microsoft Date and Time Picker Control 6.0*, and located in the Windows\System32 folder? The version I have is SP6 because it was updated when I install VS6 SP6, but yours might be a different version if it wasn't updated when you installed Office12. Note that dispite it's descriptive name it doesn't have any visible time picking features, just a dropdown arrow to display its calendar. Another control I found listed is Calendar Control 12.0 (MSCAL.OCX) located in the Office11 folder. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTPicker control missing (Win XP/Excel 2007)
"GS" wrote:
Would this be the MSCOMCT2.OCX that's listed as *Microsoft Date and Time Picker Control 6.0*, and located in the Windows\System32 folder? The version I have is SP6 because it was updated when I install VS6 SP6, but yours might be a different version if it wasn't updated when you installed Office12. Note that dispite it's descriptive name it doesn't have any visible time picking features, just a dropdown arrow to display its calendar. I searched my system32 folder and only found MSCOMCTL.OCX, not MSCOMCT2.OCX. Do you think I'm missing the DTPicker control because I'm using the trial version (12.0.6683.5002) SP3 MSO (12.0.6683.5000)? What's annoying about this is that I bought and activated the trial version way back in 2008 or so. I have a new computer since then, and trying to reinstall Office in a new PC has been difficult. I tried calling the Microsoft India hotline, in which they were able to remotely control my desktop. They claimed that my (new) computer had errors and said they could fix my software for a low price of $200. Um, fix what? Didn't I pay for this software already? Haha. Sorry, I just wanted to vent a little bit. Another control I found listed is Calendar Control 12.0 (MSCAL.OCX) located in the Office11 folder. Yes, I found the Calendar Control 12.0, but I was hoping to use the DTPicker control because I designed my app around this back in 2008. Robert |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTPicker control missing (Win XP/Excel 2007)
"GS" wrote:
Would this be the MSCOMCT2.OCX that's listed as *Microsoft Date and Time Picker Control 6.0*, and located in the Windows\System32 folder? The version I have is SP6 because it was updated when I install VS6 SP6, but yours might be a different version if it wasn't updated when you installed Office12. Note that dispite it's descriptive name it doesn't have any visible time picking features, just a dropdown arrow to display its calendar. I searched my system32 folder and only found MSCOMCTL.OCX, not MSCOMCT2.OCX. Do you think I'm missing the DTPicker control because I'm using the trial version (12.0.6683.5002) SP3 MSO (12.0.6683.5000)? What's annoying about this is that I bought and activated the trial version way back in 2008 or so. I have a new computer since then, and trying to reinstall Office in a new PC has been difficult. I tried calling the Microsoft India hotline, in which they were able to remotely control my desktop. They claimed that my (new) computer had errors and said they could fix my software for a low price of $200. Um, fix what? Didn't I pay for this software already? Haha. Sorry, I just wanted to vent a little bit. Another control I found listed is Calendar Control 12.0 (MSCAL.OCX) located in the Office11 folder. Yes, I found the Calendar Control 12.0, but I was hoping to use the DTPicker control because I designed my app around this back in 2008. Robert Perhaps you can run a repair to your office installation from Control Panel! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTPicker control missing (Win XP/Excel 2007)
Here's something that might be of interest. It's a xlsm that uses a
(pure VB) date picker Class to make a popup calendar that returns the date selected by double-clicking the target cell. I don't see why it can't be modified to work on a userform in place of the DTPicker control. It might take a bit of work on your part to impliment a combobox with it so it looks/feels/behaves like the DTPicker, but should not be very hard to do IMO! https://app.box.com/s/23yqum8auvzx17h04u4f -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTPicker control missing (Win XP/Excel 2007)
Here's a link to its source...
https://sites.google.com/site/e90e50...-control-class -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DTPicker controls missing from userform | Excel Programming | |||
DTPicker control - Initial date | Excel Programming | |||
Problem with DTPicker 6.0 control | Excel Programming | |||
Why activex calendar control 12 missing in Excel 2007 SP1? | Excel Programming | |||
DTPicker calendar control | Excel Programming |