Jumat, 06 Maret 2020

[MSAccessProfessionals] CalendarMaker for Microsoft Access

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




-=-=-=-=-=-=-=-=-=-=-=-
Groups.io Links: You receive all messages sent to this group.

View/Reply Online (#115432): https://groups.io/g/MSAccessProfessionals/message/115432
Mute This Topic: https://groups.io/mt/71782057/3568969
Group Owner: MSAccessProfessionals+owner@groups.io
Unsubscribe: https://groups.io/g/MSAccessProfessionals/leave/6606618/577250336/xyzzy [sugeng.panjalu.access@blogger.com]
-=-=-=-=-=-=-=-=-=-=-=-

Tidak ada komentar:

Posting Komentar