Calendar Maker – January, 2020

presented by Crystal Long
17 January 2020
AccessUserGroups.org
ET meeting
hosted by Dale Fye

Draw monthly calendars with Microsoft Access using a report and VBA. To make it easy, there is a menu form, but you don’t need it to make calendars. There can be a big calendar on a page with one month, or multiple calendars per page showing however many months you want to see.

To draw a calendar on any report, anywhere, whatever size you want, call the CalendarMaker sub, which has parameters for the report object, xy coordinates, width, and height. The report object doesn’t need any controls for the calendar, it just needs a page to act as a canvas to draw on. To address any coordinate on the page, the code should be in the Report_Page event.

When each calendar is drawn, the language used for month and day names is controlled by your Windows region settings. Start weeks with any day, like Sunday, Monday, or whatever you like. Show information on days using queries that you design from your database.

Was this answer helpful ? Yes / No