Jumat, 06 Maret 2020

Re: [MSAccessProfessionals] CalendarMaker for Microsoft Access

ps, here is the page with code for the Callback function:

VBA > Control > Row Source Type Callback Function

http://msaccessgurus.com/VBA/Code/ctl_RowSourceTypeFx.htm

On 3/6/2020 2:08 PM, crystal 8 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



Tidak ada komentar:

Posting Komentar