Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Making Calendar visible/invisible

Discussion in 'Information Technology' started by Stuart Grant, Nov 15, 2005.

  1. Stuart Grant

    Stuart Grant
    Expand Collapse
    Guest

    I have a data entry form and the first item is "Date of Transaction". I
    want to add a calendar to the form to make input easy. I have got the
    calendar from the Toolbox and positioned it on the form but I would rather
    it was not visible until the user presses a button beside the date text box.
    I have set the calendar visible property to No and the button's Click Action
    to Calendar5.Visible = Yes, but nothing happens.
    This seems so elementary - Every airline or hotel page has this feature.
    Why can't I do it ?
    Stuart
     
  2. Loading...

    Similar Threads Forum Date
    Partition 1947 - The Making Of Refugees History of Sikhism Mar 18, 2015
    Making The Change With Hope & Faith - Sikh Advocate Prabhjot Singh, Md Sikh Youth Mar 11, 2015
    Heritage Sikhs making Their History in Malaysia History of Sikhism May 18, 2013
    Inspirational Making a Difference: A School for Girls in Kenya Videos Mar 25, 2013
    Canada Star-struck’ security and limo drivers? Businesses complain TOIFA staff are making racist demands Breaking News Mar 18, 2013

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Instead of including multiple calendars for each field, try using a single
    popup calaendar form to do all the fields in the database. A sample is at:

    http://www.datastrat.com/Download/Calendar2K.zip

    another which uses the Windows API is at:

    http://www.lebans.com/monthcalendar.htm
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Stuart Grant" <sagrantatbluewindotch> wrote in message
    news:43786b14$1_3@news.bluewin.ch...
    > I have a data entry form and the first item is "Date of Transaction". I
    > want to add a calendar to the form to make input easy. I have got the
    > calendar from the Toolbox and positioned it on the form but I would rather
    > it was not visible until the user presses a button beside the date text

    box.
    > I have set the calendar visible property to No and the button's Click

    Action
    > to Calendar5.Visible = Yes, but nothing happens.
    > This seems so elementary - Every airline or hotel page has this feature.
    > Why can't I do it ?
    > Stuart
    >
    >
     
  4. Stuart Grant

    Stuart Grant
    Expand Collapse
    Guest

    I only have one calendar installed but Access called it Calendar5 ! I can
    link it to my data entry form and it works fine. What I can't do is make it
    appear and disappear.
    I downloaded the two sample files. The first program is very smart but I
    don't see how to use it for data entry. The Lebans sample gives
    painstakingly slow instructions for the whole thing and I think I can follow
    it and do what I want.
    Thanks for your very prompt help
    Stuart

    "Arvin Meyer [MVP]" <a@m.com> wrote in message
    news:eDOahLR6FHA.2888@tk2msftngp13.phx.gbl...
    > Instead of including multiple calendars for each field, try using a single
    > popup calaendar form to do all the fields in the database. A sample is at:
    >
    > http://www.datastrat.com/Download/Calendar2K.zip
    >
    > another which uses the Windows API is at:
    >
    > http://www.lebans.com/monthcalendar.htm
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > "Stuart Grant" <sagrantatbluewindotch> wrote in message
    > news:43786b14$1_3@news.bluewin.ch...
    >> I have a data entry form and the first item is "Date of Transaction". I
    >> want to add a calendar to the form to make input easy. I have got the
    >> calendar from the Toolbox and positioned it on the form but I would
    >> rather
    >> it was not visible until the user presses a button beside the date text

    > box.
    >> I have set the calendar visible property to No and the button's Click

    > Action
    >> to Calendar5.Visible = Yes, but nothing happens.
    >> This seems so elementary - Every airline or hotel page has this feature.
    >> Why can't I do it ?
    >> Stuart
    >>
    >>

    >
    >
     
  5. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    "Stuart Grant" <sagrantatbluewindotch> wrote in message
    news:4378bafd$1_3@news.bluewin.ch...

    > I downloaded the two sample files. The first program is very smart but I
    > don't see how to use it for data entry.


    In the double-click event of any date field control add the expression:

    =popCalendar()

    That will open the calendar. Select any date and it will put that date into
    the text box.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access
     

Share This Page