Home Tools

CalendarMaker with Day Colors

This version of the CalendarMaker gives you the ability to specify background day colors for calendars on Access reports. Color values can be in your data or calculated using a function based on your data.

Just as with the standard CalendarMaker, use queries to show information from your database, or just generate plain calendars you can print and write on.

Also added optional parameters for font name and text delimiter for multiple values on a day so you can indicate line breaks.

Quick Jump

Download Differences from standard CalendarMaker Query Fields Reference Backstory Share Donate

Goto Top

Draw Calendars on Access Reports using the CalendarMaker and specify background color for days

Goto Top

Download

To get a download link for the CalendarMaker + DayColor, donate an amount according to what the CalendarMaker is worth to you. Be sure to include your email address in the message, or email me and tell me. I'll email you a download link, not to be shared but for you only.

a fair value to get a download link for the CalendarMaker with Day Color feature. Be sure to let me know your email address.

tools@msAccessGurus.com

Note: currently only available for Access 2010 and above because it needs VBA7. It works in 32-bit or 64-bit. If you have a lower version of Access, email me to ask about availability.

License

You will get a regular ACCDB file with source code. You may not sell it in whole or in part. You may include it in applications you use yourself, and that you develop to help others. If other developers want to use this feature in database applications they build, they need to make their own donation. Keep attribution. Use at your own risk.

Goto Top

Query Fields

Holiday and Calendar data Queries

This version has an additional field, DayColor, that you can specify in your data queries.

Calculated Field name	Data Type	Description	Holiday Query	Calendar data Query
CalYr	Integer	4 digit year you can use the Year([datefield])	✓	✓
CalMo	Integer	month number, 1-12 you can use the Month([datefield])	✓	✓
CalDa	Integer	day number, 1-31 you can use the Day([datefield])	✓	✓
Text1	Text	text to print on day Holiday in upper left, Calendar data in middle of day cell	✓	✓
IsBold	Boolean	True for bold text	✓
DayColor	Long	New! Color number or RGB color for day background color		✓

Goto Top

Differences

Major differences between this version and the standard CalendarMaker is an enhanced module with the VBA code that makes the calendar, and ability to take a DayColor query field into account.

Day Color
When you want day colors, simply add a field called DayColor with a long integer color number to your data query.
Use a negative number or Null if you don't want to change the day color.
Two example queries are added with "DayColor" in the name so you can find them easy. It isn't necessary to put DayColor in the query name because the VBA code checks to see if the field is there.
In the sample data, day colors are coming from a table, but you could define a function to calculate them based on parameters you send.
Font Name is an optional parameter, psFontName
TextDelimiter is an optional parameter, psTextDelimiter
If you want line breaks instead of commas between data when there is more than one value for a day, use "~NL~"
For comma, use ", " (don't forget the space). Default is now a new line and font size is slightly smaller to accomodate more text.
Sample and holiday data includes 2023 and 2024 so you can test with current information.
Solstices, equinoxes, and full moons added to holiday data in cal_HolidayCtry for 2023 and 2024. No country is specified, so if you want to include them, be sure to let Ctry be Null in your Holiday query for the calendar.
The qrHolidays_US example query is modified to show solstices, equinoxes, and full moons.

Goto Top

Reference

Help and Videos on standard CalendarMaker page

Report Draw Reference for VBA syntax and help for drawing on Access reports.

Goto Top

Backstory

I'm hoping that those who've benefitted from the CalendarMaker, which has been downloaded lots of times and is being used all over the world, won't mind givng a little to get this improved version. It includes source code, just like the standard version.

here's the link to copy:

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

Do you want tutoring?

Do you have a project that could benefit from an expert developer helping you? Let's connect and build your application together. As needed, I'll pull in code and features from my vast libraries, cutting out lots of development time. Let's build whatever you're working on together! I look forward to hearing from you.

Email me anytime at training@msAccessGurus.com
~ crystal
let's connect and team-develop while we build your application together.

Goto Top