Creating an Interactive Calendar in Access

[xian2]

Hi,
I am doing a school coursework project that in Access for my Father's touring business.

The database will contain tables holding details of the client (and their requested tour date and type), the tour types available and the ferry arrangements.

I would like to create an aesthetically pleasing calendar that holds details of the client name, tour type (e.g. American - 1 Day) and shows this so at a glance it is possible to see what days are booked up and which days are free.
Also, some kind of colour scheme would be useful to draw attention to the booked days, e.g. if a tour is entered for a day then the box goes red.

Many thanks in advance for any help you may be able to provide

Edward

[blyxx86]

Hi,
I am doing a school coursework project that in Access for my Father's touring business.

The database will contain tables holding details of the client (and their requested tour date and type), the tour types available and the ferry arrangements.

I would like to create an aesthetically pleasing calendar that holds details of the client name, tour type (e.g. American - 1 Day) and shows this so at a glance it is possible to see what days are booked up and which days are free.
Also, some kind of colour scheme would be useful to draw attention to the booked days, e.g. if a tour is entered for a day then the box goes red.

Many thanks in advance for any help you may be able to provide

Edward

The one thing I can think of is to use one of the calendars already premade in Access. On the form design tools there is an option for "More Controls" and use the "Calendar Control 9.0" or just look through the list, there is a Microsoft Time and Date control that also works.

Have this lookup some information to display in list, almost like a table within the form.

I think it could look fairly good doing it this way, and is very usable. However, you may need some help binding the date you select to what information is displayed. I haven't quite figured that one out.

[NeoPa]

Good to see you posting Blyxx86 - We'll make a full expert of you yet :)

[xian2]

Thank you so much for your help, the calendar control makes it look great.

However, I am pretty new to Access and am not sure how you would lookup the details and dates from another table. Any suggestions?

Thank you in advance

Edd