Calendar question

[nmajdan]

Ok, i'm going to be developing a database. It will be a reservation system for a retreat. There are multiple buildings on the campsite. I want to be able to click on a date in the calendar, and then have what buildings are reserved for that date appear in text boxes below the calendar. Whats the easist way to do this?

 

[djl0525]

Sometimes it helps to look at existing databases when starting an application from scratch. With that in mind, you might want to look around the Resource Scheduling database, the template for which comes with Access. New database, General Templates, Databases page... This database is probably not exactly what you have in mind, but it might give you some insight as you get started. I recommend that you examine the tables in this database and their relationships. You can also look at Microsoft's online templates at http://office.microsoft.com/en-us/templates to find others that will help you on your path.

DJ

 

[nmajdan]

Thanks for the advice. I went through a bunch of templates and couldnt find what i was looking for. also searched through the access newsgroup forum on microsoft.com. nothing. has no one ever tried to use the calendar control for this?