By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 953 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

Creating an Interactive Calendar in Access

P: 43
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
Nov 29 '06 #1
Share this Question
Share on Google+
3 Replies


blyxx86
100+
P: 256
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.
Nov 29 '06 #2

NeoPa
Expert Mod 15k+
P: 31,661
Good to see you posting Blyxx86 - We'll make a full expert of you yet :)
Nov 30 '06 #3

P: 43
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
Dec 1 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.