calendar

[gneff]

I am intrested in using the active x control that is provided in access "calendar control" to display all projects and dates of installation. I have a single table which includes "shipdate" "id" and would like to show the id# at the appropriate date. The table is imported from a larger visual mfg database and is to provide an easier interface to view all projects and the appropriate scheduled date. It would be great if I could have a detailed report pop up but that maybe unnecessary as I could program the select of a particular date as the determiner of what data I want to display below the calendar. Any help is appreciated.

 

[Darrylles]

Hi,

Sorry, could you explain exactly where you are stuck?

You haven't mentioned what the problem is.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[gneff]

Thanks for the response my intent is to display the calender in a form and have it show all dates that projects are scheduled to be installed. This would be all records not a single date. Rather than have the date shown depressed which appears to be the default of the active x control, I would like to see the ID# or project number shown in the calender below the appropriate date. So I want to display [ID] at the [installdate] on the calendar. Further I would like to have the ability to click on the [id] to either pop a detail form with more information on that project. Or simply use a tab setup on the form and let the selected [id] be the source for a query that will show on a seperate tab. Hope this is clearer.