Re: [MSAccessProfessionals] CalendarMaker for Microsoft Access

Crystal,

You are ever the champ!  Thank you,

On Mar 7, 2020, at 9:08 AM, Adeboyejo Oyenuga via Groups.Io <aoye_99=yahoo.co.uk@groups.io> wrote:

Thanks Crystal.

Ade

On Friday, 6 March 2020, 20:08:05 GMT, crystal (strive4peace) via Groups.Io <strive4peace2008=yahoo.com@groups.io> wrote:

hello Access lovers,

I want to share my CalendarMaker with you. As its name implies, it makes

calendars in Access. It uses a report to do this. The drawing and

writing is done using report.Line and report.Print methods, not using

controls. Calendars are scaled and can be positioned anywhere on the

page, so there can be a big calendar on each page with one month, or

multiple calendars per page showing however many months you want to see.

The report itself can be one page, or several. You can also output to

PDF for easy sharing.

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.

Make your own calendars!

Download the CalendarMaker ACCDB, from:

https://msaccessgurus.com/tool/CalendarMaker.htm

This page describes what fields you must put in a query to use it for

the calendar if you want data from your database to be displayed. It

also has a list of objects to get if you want to import the

CalendarMaker into another database.

I gave a presentation of the CalendarMaker that is here:

CalendarMaker presentation video

https://www.youtube.com/watch?v=okl2gzlR3Is

The CalendarMaker uses a callback function on its menu form to show

information in a listbox to pick first day of week using day names that

change based on your Windows Region settings. Here is a video showing

how this works:

RowSourceType Callback Function in Microsoft Access

https://www.youtube.com/watch?v=oA1bC8uhqAY

The menu form is not required to use the CalendarMaker, just makes it

easier to set variables like date, first day of week, holiday query, and

calendar data query. I spent a bit of time putting in holiday

information for America as well as a few other countries -- and each has

a query you can pick to show holidays of your choice. There is also a

crude feature for entering dates of sporting events, so if you're a

sports fan, you can print calendars showing when your favorite teams

will (or did) play.

I plan to add more features, at some point since, as you know, an Access

database application is never done -- there is always more!

Hope you like it. I'd love to hear your comments, thanks.

kind regards,

crystal