Microsoft Date and Time Picker Issue

Question

Hi everybody,

I have an issue with my "Microsoft Date and Time Picker" controls since my company migrated its workstations to Windows 7 - 64 bits. For compatibility reasons, the office 2010 installed on these machines is a 32 bits version.

Browsing several forums, I already checked the following without success :

- mscomct2.ocx file is located in C:\Windows\SysWOW64 --> Seems OK

- Tried the cmd "regsvr32 c:\\windows\SysWOW64\mscomct2.ocx" with admin rights. It completed successfully but did not solve the issue.

I'm now completely lost and do not know what to do...

Could anybody help?

Thanks in advance,

Best regards,

Pierre

Answer 1

Look closely at what you did

"regsvr32 c:\\windows\SysWOW64\mscomct2.ocx"

 

You registers a 64 bit control using a 32 bit command!

---

jdweng

Answer 2

Hello Joel,

Thanks for your reply!

That's what I found on other forums... By the way, these controls are 32 bits controls that have to run on 64 Bit OS with 32 bits office 2010...

Answer 3

It looks like you have done everything correctly, does this work

Set obj = CreateObject("mscomctl2.dtpicker")

If not...I had a problem registering mscomctl2.ocx even in W7 32bit. I know it sounds stupid but try repeating the same regsvr32 process. Each time look for "Microsoft Date & Time Picker Control etc" in additional tools in the toolbox, also look in tools/references for "Microsoft Windows Common Controls-2 6.0 (SP6)" and if not there maybe browse to mscomctl2.ocx.

Peter Thornton

Answer 4

Pierre:

You may want to review this link:

Date Picker Fix

The note is for MSCAL.OCX but the process is the same for mscomct2.ocx.

Regards,

---

Rich Locus, Logicwurks, LLC

http://www.logicwurks.com