You could try this:
Graham R Seach
Microsoft Access MVP
"Robert Robinson" wrote in
I am creating an application which will help to schedule appointment times.
have seen where you can tap into ActiveX to access a pop-up calendar, but
want to take it a couple of steps beyond. What I would like to do is
calendaring function that:
* Knows and avoids weekends and non-office hours during weekdays
* Validity checking (or macro script) that will not allow an appointment
be scheduled at a time when an appointment already exists.
I can think of ways to do this that might work (starting with the most
intensive - loading in valid values for appointment dates and times, then
basing a "calendar" form on this table), but I am wondering if someone has
already invented this whell and would not mind sharing their insights.