Calendar on report

[Tom]

Hello and thanks in advance for the help.

I have a report based on a parameter (starting and ending date) query.
Currently, to run the report, one must enter each date in a separate box. Is
there a way to make this easier for the end user? I'm thinking of a calendar
like on travelocity or similar, where one can click on the calendar icon and
select dates.

 

[Larry Daugherty]

Hi Tom,

I have my applications pop up a calendar any time a textbox on a date
field is double-clicked with the date already in the textbox selected
on the calendar. If it was empty then today's date is selected..
Navigate to the desired Year, Month and day and doubleclick to return
the selected date to the textbox.

I use code and a calendar form from Ken Getz et alia that I started
using in Access 2.0 and tweaked to keep on working with the newer
versions. I believe I got the original off a floppy accompanying "The
Access [YourVersion] Developer's Handbook". I just peeked in the
Access 2000 edition and they're still providing it. I highly
recommend it. It's better than an ActiveX calendar from Microsoft
because it's all code, thus immune to Access and Windows versioning
problems.

I also put in some more code from the same source to spin the day
component of the date in the selected textbox by pressing the number
pad "+-" keys

HTH