Calendar

[Tara]

Not sure where to post this, but I think this is the best
place. Is there a way to insert a calendar where the
user could actually type something on a specific date (or
dates) and then use this as criteria in a query? I ask
because I am working on a new attendance tracking
database for my company where this would be useful.
Currently the user clicks on a date, which opens up a
form where she enters the type of leave (Vac, sick, etc.)
then the amount (either .5 or 1). If an employee is gone
on vacation for ten days, she has to make ten such
entries. I'm trying to simplify things for her and she
really likes the calendar aspect because she is such a
visual person.

Thanks
Tara

 

[Guest]

Hi Tara

Check out
http://msdn.microsoft.com/library/d...en-us/bapp2000/html/acbachap09.asp?frame=true.

There's essentially two ways to use this calendar component 1) user clicks
on the calendar, you can pass the selected date back into your query or 2)
user types a date and the calendar displays it.

If you put two calendars on a form, you can pass the values to a start and
end date paremeter of your query. I've got a bit of code that works out the
number of working days between the two if you want it?

Hope this helps