Date Time Picker control is not working on every system

[Sachin Agrawal]

Hi guys
I'm a VBA Developer. I developed some VBA programs (See & download at www.excelapps.webs.com). Some of these programs uses a window control named Windows date-time Picker control. Library of this control is ‘mscomct2.ocx’ default directory for which is c:\windows\system32\ on 32 bit system & c:\windows\syswow64 on 64 bit system.

Problem is that this control is not available on all systems. On most of the system it works after copying its .ocx file to the default directory and then registering it through the command line using Regsvr32 c:\windows\system32\mscomct2.ocx but on some systems (64 bit as well as 32 bit) this registration process failed giving the message ‘The module was loaded but call to DllRegisterServer failed. Error code 0x8002801c.’ In that case control do not work on that system.

I have to find out the reason for this.
Can anyone help me??

 

[PeterB]

In 64 Bit Windows, try running the following in elevated command prompt:

C:\Windows\SysWOW64\
regtlib msdatsrc.tlb

See:
http://stackoverflow.com/questions/...ocx-after-update-kb-2687323/16274064#16274064 and

http://stackoverflow.com/questions/...windows-common-controls-6-0/15785253#15785253

 

[Sachin Agrawal]

Thanks peter but still it is not working.

 

[KenU]

It is my understanding that the date/time picker control is no longer supported. I found a calendar control class at the link below. It was very well done.

https://sites.google.com/site/e90e50/calendar-control-class

Regards,
Ken

 

[SirJB7]

Hi, Sachin Agrawal!

As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, KenU is right, it's no longer supported nor available. So you'll have to find another ways of entering dates of use other solutions like that of the posted link.

Regards!