Welcome to SPN

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

Sign Up Now!
  1. Guest ji, please consider donating today!
      Become a Supporter    ::   Make a Contribution   
    Monthly Recurring Target: $300 :: Achieved: $95

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page