Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Crestview Hills, Kentucky, USA
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calendar Control (Access 97)

    I have a form based on a table. One of the fields is a date field.

    I'd like for the combo box arrow to produce a little calendar that I can navigate around in, click on a date, and have that date placed in the Meet Date field in the table.

    I know nothing about VB programming.

    Thanks,
    Craig.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Calendar Control (Access 97)

    The control you want is the Date/Time Picker. Look in the additional tools list in the toolbox for Microsoft Date and Time Picker Control. I'm not sure what version would be on your machine. On mine it's version 6 SP4. If you don't see it listed, you may have to add a reference to the Microsoft Common Controls or the Microsoft Calendar Control. I can't recall which file actually contains the date/time picker.
    Charlotte

  3. #3
    Lounger
    Join Date
    Mar 2002
    Location
    St Albans, Hertfordshire, England
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calendar Control (Access 97)

    There are a number of advantages of using each type of control - especially when it comes to placing ocx controls on Tab pages.

    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15> I used the Date/Time picker control on a tabbed page - unfortunately, every time a user selects the 'Add New' button, the DTPicker Control would move itself to the top left corner of the screen, and would only move back once the user started typing in any of the other controls!

    <img src=/S/argue.gif border=0 alt=argue width=50 height=25> I know that there are differing opinions on using Microsofts Tab control, as opposed to a third party's like FMS, and the way that some ocx's interact and react.

    <img src=/S/trophy.gif border=0 alt=trophy width=15 height=15>Trial and error generally wins through!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calendar Control (Access 97)

    There are 2 different controls:

    Calendar control 8.0 is part of Office 97. It looks like a calendar. The associated file is mscal.ocx in the system folder (WinNTSystem32 or WindowsSystem or ...).

    The Date / Time picker is part of Microsoft Windows Common Controls 2 which comes with VB6. It looks like an ordinary combo box, but when the user clicks the drop down arrow, a calendar instead of a list is shown. The associated file is mscomct2.ocx, also in the system folder. I don't know if this can be distributed freely.

    By default, a reference to the ocx is added automatically.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Calendar Control (Access 97)

    <hr>unfortunately, every time a user selects the 'Add New' button, the DTPicker Control would move itself to the top left corner of the screen, and would only move back once the user started typing in any of the other controls!<hr>
    That sounds like a problem with your form design. I've used the DTPicker on Access-native tab controls without any problem.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •