Room Booking

[Dave Eyley]

Hi All,

I am in the process of creating a Room Bookings database using the limited graphical tools of Access 2003.
I intend to break up the day from 0700 to 1900 into 48 X 15 minute chunks (the minimum bookable time) and have these graphically represented on the form as boxes whose colour change depending on whether it is booked and who by.
It would be normal to have up to 8 colours available for this as any one room would be unlikely to be booked by more than 8 people in one day.
I would envisage that each day would be covered by a separate subform.

Has anyone else tried a graphical representation of a booking form?

It would be interesting to hear others views or experiences...

Dave E

 

[pono1]

Dave,

Reading your post reminded me of an excellent sample posted by ChrisO that illustrates a dynamic, color-coded interface using Access 97. Perhaps it can generate some ideas for you.

Regards,
Tim

 

[Dave Eyley]

Thanks for the link Tim. Interesting method for reading the seat details without clicking. I may find a use for that... It's a shame that Access doesn't have a few more graphical tools so that we could develop applications and not just databases...

Thanks again..

Dave