handyman at actcom.co.il
handyman at actcom.co.il
Thu Feb 17 19:31:40 CST 2005
There's a calendar/schedule module used in an automotive database at http://www.arcpress.com/software/index.html That should give you some good ideas. If anyone knows of any other open source database out there, please post them. They're a great learning tool - and for ideas..... gm At 05:23 PM, 2/3/2005 -0500, you wrote: >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 Gershon Markowitz mailto:Handyman at actcom.co.il http://www.yadchaimtzvi.org