DTPicker control missing (Win XP/Excel 2007)

[Robert Crandal]

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!

 

[GS]

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

 

[GS]

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

 

[Robert Crandal]

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

 

[GS]

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.


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

 

[GS]

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

 

[GS]

Here's a link to its source...

https://sites.google.com/site/e90e50/calendar-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