[AccessD] Calendar Software Search - Revisited

Keith,

Sending you a small sample off-line that might spark some ideas.  Hope
it helps . . .

Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith
Williamson
Sent: Thursday, February 03, 2005 2:24 PM
To: dba-OT at databaseadvisors.com; Access Developers discussion and
problem solving
Subject: [AccessD] Calendar Software Search - Revisited


Hi All....I'm trying again on the Calendar issue.
 
I wouldn't think this would be so hard...but so far it has been
impossible.
I need a calendar software that links to Access.  The major criteria
are:
 
1)  Must have monthly display format (ie.  various daily tasks/events
display, in summary, on the monthly layout);
2)  Must handle multi-day scheduled tasks (ie.  enter begin and ending
date,
it reflects on calendar);
3)  Would like to have different color for priority tasks/events;
4)  Must allow me to edit the tables and add forms for additional
information, when drilling down on a daily task;
5)  Basically look like MSOutlook, but when drilling down on the daily
event, get custom forms that I can create/edit.
6)  Must allow for direct data input to calendar tables (I don't want to
have to import/export)
 
 
What I need to do is have the ability to display (in a monthly format)
multiple events on a daily basis, that I can drill down on to get
additional
detail.  The reason I don't want to use Outlook is that I want to be
able to
do calculations on the detail behind the events.  The purpose is for my
business.  We do a LOT of craft shows on weekends.  Typically, this time
of
the year, I am evaluating all the different events for the year.  I
schedule
them all out, and start doing cost/benefit analysis on them.  I
literally
have hundreds to choose from...and plan on doing between 30 - 40
events......but want to have the information for ALL available (that I
know
of).   On any given weekend, I could have anywhere from zero events to
choose from, to 5 or 6 events ( in the long run it could be even more.)
I
need to store information about past history of the event (if we did it
in
the past....such as booth fees, attendance, sales, maybe weather,
mileage to
the event, travel expenses, etc.)  I need to be able to see all the
possible
events for the month....so each day would need to be able to auto-expand
if
there are more than the standard 4-5 lines of events for that day.  I
also
want to be able to just set the duration of the event, and have it
auto-fill
the event for all the days.  It is very important that I can see the
whole
month, at a glance.  Then drill down on the detail.  I envision a
check-box
that I can select which event (or more than one event) for the
day...which
might change the color for the event on the month-view.   This way...I
can
basically select all the events I am interested in....an apply for them.
If
I can't get into one that I wanted....I can go back to that weekend, and
see
if there are any other events I might be interested in.  Once the events
are
selected...I can effectively budget sales and costs for that segment of
the
business, for the year.  I can also use this to develop employee
schedules...as I would know when I needed additional coverage in the
store.
 
If anyone has any idea where I can buy such a product...PLEASE, PLEASE
let
me know.
 
Many thanks,
 
Keith E. Williamson
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com