Calendar Maker with day colors, small Ms Access Gurus
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.

Donate

a fair value to get a download link for the CalendarMaker with Day Color feature. Basically, it's more information you can put in your query that the calendar code can understand. You also get source code, so can customize as desired. Be sure to let me know your email address so I can email you the download link!

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.

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.

Share

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