A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Smart" calendar functionality...is it possible?



 
 
Thread Tools Display Modes
  #1  
Old September 13th, 2005, 02:47 PM
Robert Robinson
external usenet poster
 
Posts: n/a
Default "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
Ads
  #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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 05: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


All times are GMT +1. The time now is 01:20 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.