Keith Williamson
kwilliam at ashlandnet.com
Thu Jan 27 10:42:09 CST 2005
Can anyone recommend something for me, for the following process I need to do? I need to create a MSOutlook-type Calendar in Access. 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. Right now, I am basically doing this in Excel, with linked cells for the calculations....but I'm sure you can imagine the limitations. Does anyone know of A) anything canned that I can use as a start, and add on to it; or B) a methodology for doing this in the first place?...Obviously, the active-X calendar that comes with Access won't work. Thanks for any feedback!!! Regards, Keith E. Williamson