How to install MS Date Picker in Access 2003

[Alex E.]

How do I get Microsoft Calendar Control 11.0, Location C:\Program Files\MS Office\Office\MSCAL.OCX installed into a MS-Access 2003 Form?

Here is what I do:

• Tools menu/ Active X controls/ Calendar Control v. 11.0
• Then I click Register
• On the next screen:
  • File Type: Control (preselected)
  • File Name: nothing works in this box; when I hit Ok = the file name I have entered gets a blue background and no reaction

At the bottom of the screen it reads:
Control location: C:\Program Files\MS Office\Office\MSCAL.OCX

Questions:

• Anything I have done wrong so far?
• Could it be that the file listed at the bottom of the screen isn’t installed on my computer – if yes, where would I find it on my Access Program CD and how would I install it?
• A Google Search brought up a comment about using the Insert menu/ Active X Control. But, this option is not available on my Insert menu. I also tried Toolbox/ More .. and selected the Calendar Control 11.0 there from the dropdown list. But, I cannot even get as far as the Registration screen.
• There also seems to be another hurdle in waiting for me once I get the Calendar control registered. The following is a short clipping from an old forum thread that ended inconclusive as far as I can tell:

“…. I am still unable to get the AttachToCalendar method of the DatePicker control to become available in Access 2003…..”

Note: there is no input mask on my date fields.

 

[JANR]

See if this link helps: http://www.fontstuff.com/access/acctut09.htm

JR

 

[Alex E.]

Hallo JR
thank you for the link you posted. It's the "missing manual" so to speak. So far, I have been able to put the calendar on the form. I hope, I will can manage to bind it to the date fields and add the popup quality as well.

I may be back with questions about the code needed to make it all work. At first glance, I cannot detect any field names that I would have to change.