View Single Post
  #2  
Old September 13th, 2005, 03:29 PM
Graham R Seach
external usenet poster
 
Posts: n/a
Default

Robert,

You could try this:
http://www.dbi-tech.com/Product_Page...s_Schedule.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Robert Robinson" wrote in
message ...
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.
--
Robert Robinson