Results 1 to 4 of 4
  1. #1
    alexcalgary is offline Novice
    Windows XP Access 2003
    Join Date
    May 2009
    Posts
    3

    Access 2003 - how install MS Date Picker

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



    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 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 once I get the Calendar control registered. The following is a short snipped 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 the date fields.

  2. #2
    ansentry's Avatar
    ansentry is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    May 2009
    Location
    Melbourne, Australia
    Posts
    67
    With the form in design view;

    Go to View / Toolbox
    With the toolbox open, select the last icon (bottom right hand corner), now look for Calendar Control 11.0, click it with the left button now put your mouse on the form, you will see a little hammer. Click the form and re-size it to your liking.

    Have a look at my sample, it may help.

    Regards,

    John A

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If you want a Calendar that does not take up any space on your form, there are many in this list from Jeff Conrad.

  4. #4
    alexcalgary is offline Novice
    Windows XP Access 2003
    Join Date
    May 2009
    Posts
    3
    Hallo John A.
    thank you for the tip. It worked perfect on the first try.
    Seems, I got confused by the menu method where this "register" screen caused me such a headache.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access 2003 Date() Function returns "#Name?"
    By smartel@soprema.ca in forum Programming
    Replies: 5
    Last Post: 01-18-2012, 05:52 AM
  2. converting from Access 2003 to Access 2007
    By LawrenceLau in forum Access
    Replies: 6
    Last Post: 11-20-2008, 03:53 PM
  3. Access Runtime 2007 Date Time Picker Vista not working
    By sailinxtc in forum Programming
    Replies: 0
    Last Post: 09-17-2008, 12:56 PM
  4. Microsoft Date and Time Picker 6.0
    By That Crazy Hockey Dood in forum Forms
    Replies: 0
    Last Post: 07-25-2007, 03:22 PM
  5. Replies: 1
    Last Post: 09-06-2006, 11:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums