OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   Database Design (http://www.officefrustration.com/forumdisplay.php?f=27)
-   -   "Smart" calendar functionality...is it possible? (http://www.officefrustration.com/showthread.php?t=294391)

Robert Robinson September 13th, 2005 02:47 PM

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

Graham R Seach September 13th, 2005 03:29 PM

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





All times are GMT +1. The time now is 05:11 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
OfficeFrustration.com