If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calendar Copying Issue | David Landers via OfficeKB.com | Calendar | 0 | May 31st, 2005 07:44 PM |
Calendar Question | Josh | General Discussion | 7 | March 28th, 2005 11:19 PM |
Calendar Items disappear, or marked as Tentative, When Delegate involved | Lyle Kelley | Calendar | 1 | November 27th, 2004 04:40 AM |
Calendar View/Pane | Andy | General Discussion | 0 | August 25th, 2004 03:15 PM |
Functionality problems with Outlook calendar | Mary | Calendar | 1 | May 19th, 2004 10:32 PM |