Making Calendar visible/invisible

[Stuart Grant]

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

 

[Arvin Meyer [MVP]]

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]

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]]

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