Need help populating calendar form in Access 2010 to view when jobs are due

[hmoritz72]

I am putting together a database for manufacturing jobs (very small company). My boss would like to a see a calendar view of when jobs are coming due that particular month or following months so that we don't have too many jobs going out on a specific day. It is just a visual. I have created a simple calendar in the program but cannot figure out (or remember) how to populate the days with the information (it merely populates the day of the month at the moment). I only want it to show the job number on the date it is due. It would be fabulous to be able to dbl-click on the job number to go to that record but not necessary. I set up a simple query pulling only the job number and the due date but beyond that, I am lost on what to do next. Any ideas? I am open to having it show on a report instead also. He really wants it in Access, although I am wondering if there is a way to connect it to his Outlook calendar somehow??? That would be an option too. I am grasping for anything at this point... frustrated!

Thanks for any advice provided.

Heather

[Micron]

I recall seeing this in the forum before and found a file I downloaded. Unfortunately, I cannot find where I got this from so I apologize to the creator for not being able to give credit. Can't tell you anything about this as I've not studied it, but I grabbed a copy because it looked real good. If anyone recognizes the file and knows the source, please provide the due credit.

Outlook_Style_Calendar_V3c.zip

[CHEECO]

The file comes from this site and was created by Peter Hibbs. http://www.utteraccess.com/forum/Ms-...-t1969978.html