I am using the MS Access Calendar in Access 2013, Windows 8.
http://bytes.com/topic/access/answer...alendarhttp://
Currently I am using 4 calendar forms with the data source supplied by 4 different tables.
Table 1 = Holidays
I use the form to print a blank calendar (blank = does not include scheduling info). Holidays are treated as part of a blank calendar like you would buy for your wall at home.
Table 2 = Events
No printing needed but I will be attaching a form to the blocks in this calendar.
Table 3 = Courses (Education Classes)
No printing needed but I will be attaching a form to the blocks in this calendar.
The forms are VERY different for Events and Courses. I am unaware of a way to attach 2 forms to one block so I used 2 calendar forms. Additionally, I am not sure I would want to. It might make data entry more confusing.
Table 4 = Tables 1, 2, and 3 combined for a complete calendar view. Mostly used for printing.
I did it this way so I could use it now and I am working on the elimination of multiple tables. I originally could not get the calendar form to accept a Query as its source. This has magically ceased being an issue (I think). The end result will be a Query holding the info needed to feed any form with a field (Calendar Category) specifying Event, Course or Holiday.
I am hoping I can add a filter to the calendar form to only display information in the Query where, for example, Calendar Category = Event.
Or possibly use one calendar and have a control to choose between multiple views.
My question is: How can I filter the displayed information on the calendar form?
Thanks for Looking...Have a Thrilling Thursday!