"Smart" calendar functionality...is it possible?
I am creating an application which will help to schedule appointment times. I
have seen where you can tap into ActiveX to access a pop-up calendar, but I
want to take it a couple of steps beyond. What I would like to do is create a
calendaring function that:
* Knows and avoids weekends and non-office hours during weekdays
* Validity checking (or macro script) that will not allow an appointment to
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 labor
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. Thanks.