Outlookstyle Scheduler

[bartus991]

For an event database in access if have created a static overview of the planned events. It looks like:

Auditorium    Event            Start Date    End Date
Milano        EventMilona      01DEC2012     05DEC2012
London        EventLondon      03DEC2012     06DEC2012

Per event I created a detailed programm:

Auditorium Event         Date      Time  Duration  Description
Milano     EventMilano   01DEC2012 13:00 90MINS    Lunch

I would like to create a graphical display like the outlook planner, or the image in the attechment.

Is this possible in MS Access and how?
And if it is possible. Can a event be changed by simply drag an drop?

 

[MajP]

It can be done, but there is no native control to do this. I have done it several different ways, but all require extensive vba experience. Unless you are an advanced access programmer, I would look for a third party add in. However one thing, do not break up date and time. It should always be a single field.
Ex: dtmStart 12/01/2012 1:00:00 PM

All "date" fields store a date and time component. This field can be formatted into any date/time/date & time format. Do not store the duration. That is a calculated field. You could have a duration control on a form that sets the end date time.

 

[MajP]

If you google, there are a few free versions out there:

http://www.utteraccess.com/forum/Appointment-Scheduler-da-t724942.html

http://www.pcreview.co.uk/forums/appointment-schedule-design-t3459134.html

I will dig out a couple of my examples.

 

[dhookom]

As MajP suggests, building an interface (forms) like this is a complex task that is probably better off handled with a third party solution.

There are report sample at Hook'D on Access for week at a glance and similar display.

Duane
Hook'D on Access
MS Access MVP