Calender / date control

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Denis

    Calender / date control

    I have a field called date . I want to have a drop down box which,
    when you chick on it, will show a calendar. Upon selecting a date from
    this calendar it will put the selected date in the “date” field. It is
    a similar idea to what you see on travel websites when booking trips.

    Any ideas. Thanks

    Denis
  • james.igoe@gmail.com

    #2
    Re: Calender / date control

    - date field should be text box
    - add calendar to form, partially covering text box, and set calendar
    visible = no
    - code the text boxc click event:
    1. opens ocx calendar
    2. if date not empty, sets date of box to calendar, else sets as
    today
    - code calendar click event
    1. set text box data to value of calendar
    2. hide calendar
    - after code works, have calendar control completely cover text box -
    users should not have the ability to enter values directly

    James Igoe





    On Jun 9, 10:50 am, Leslie Porter OHV



    On Jun 11, 11:43 am, Denis <denisphe...@gm ail.comwrote:
    I have a field called   date .  I want to have a drop down box which,
    when you chick on it, will show a calendar. Upon selecting a date from
    this calendar it will put the selected date in the “date” field. It is
    a similar idea to what you see on travel websites when booking trips.
    >
    Any ideas. Thanks
    >
    Denis

    Comment

    • ARC

      #3
      Re: Calender / date control

      In access 2007, date fields will automatically display a built-in calendar
      button. Just fyi...


      "Denis" <denisphelan@gm ail.comwrote in message
      news:1a254529-2b45-4d18-8b23-cb961000d5d9@y3 8g2000hsy.googl egroups.com...
      I have a field called date . I want to have a drop down box which,
      when you chick on it, will show a calendar. Upon selecting a date from
      this calendar it will put the selected date in the “date” field. It is
      a similar idea to what you see on travel websites when booking trips.

      Any ideas. Thanks

      Denis

      Comment

      • Tony Toews [MVP]

        #4
        Re: Calender / date control

        Denis <denisphelan@gm ail.comwrote:
        >I have a field called date . I want to have a drop down box which,
        >when you chick on it, will show a calendar. Upon selecting a date from
        >this calendar it will put the selected date in the “date” field. It is
        >a similar idea to what you see on travel websites when booking trips.
        See the Calendar Tips page at my website


        There could, likely will, be lots of version problems when you go to distribute the
        MSCal.OCX..

        One alternative is MonthCalendar is a completely API generated Month Calendar derived
        directly from the Common Control DLL. There are links to several downloadable
        calendar forms at my website. As these are forms you can also do anything with them
        you want.

        You can also use the calendar form which comes in the Access <insert your version
        hereDevelopers Handbook by Litwin/Getz/Gilbert, publisher Sybex
        www.developershandbook.com. These books are well worth spending money. Every time I
        open one I save the price of the book.

        Duane Hookum has an awesome and simple calendar in a report. See the Calendar
        Reports sample section at http://www.access.hookom.net/Samples.htm

        Tony
        --
        Tony Toews, Microsoft Access MVP
        Please respond only in the newsgroups so that others can
        read the entire thread of messages.
        Microsoft Access Links, Hints, Tips & Accounting Systems at

        Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

        Comment

        Working...