Calendar stuff (1 Viewer)

Darrell

Registered User.
Local time
Today, 03:01
Joined
Feb 1, 2001
Messages
215
ok so my workplace decides that it would be great fun for us to upgrade from 2007 to 2010 and my worksheet calendars stop working.

Turns out that MS in their infinite wisdom have stopped using the Calendar Control and replaced it with something else like DatePicker. So after much research I find that I have to register an .ocx file to make it available in 'Active Controls' so I can create a userform, select 'Date Picker' and add it to the form.

However when I try to do that it come up with an "Element not found" error.

Now what...? no help available from here on in by looks...

This is driving me insane......
 

noboffinme

Registered User.
Local time
Today, 13:01
Joined
Nov 28, 2007
Messages
288
Hi Darrell,

I think you need to go & select the Calendar from the Excel Reference Library.

Go to your Visual Basic code window & at the top select 'Tools' >> 'References' & you'll see the boxes that are checked are available to you. If you look for a Calendar Element & check that box, you will have that available.

I'm using 2007 so I can't advise exactly what to select but it will have calendar in the name, possibly around the Microsoft products down in the 'Ms'.

Have a read of this;

http://www.cpearson.com/excel/missingreferences.aspx
 

noboffinme

Registered User.
Local time
Today, 13:01
Joined
Nov 28, 2007
Messages
288
I have some more info, the below link shows you what to do & where you can find the MSCAL.ocx file.

Thinking about it, as I had used this feature some time ago, I had to get the file & everyone who used the database had to also have it so it wasn't useful & I replaced it with the normal date input mask.

Hth,

http://community.spiceworks.com/how...-mscal-ocx-reference-in-microsoft-access-2010
 

Darrell

Registered User.
Local time
Today, 03:01
Joined
Feb 1, 2001
Messages
215
Thanks for the info guys.

I have already tried registering the mscomct2.ocx file as per these instructions

http://www.logicwurks.com/CodeExamplePages/EDatePickerControl.html

and I got a message saying it was sucessful.

However, then when i go into 'More controls' the date picker is not available on the list.

Also - there is no reference to any ActiveX component in the reference list.

:banghead:
:banghead:
:banghead:
 

Darrell

Registered User.
Local time
Today, 03:01
Joined
Feb 1, 2001
Messages
215
Finally solved this.
Turns out I had to download an updated copy of this file and re-register it. All works now - even though it is a far inferior version of what Excel was providing previously.
 

Users who are viewing this thread

Top Bottom