Translate this page
Provided By Microsoft® Translator

Home Tools

Tool > Date and Time > Calendar Report (HTML Web page or PDF)

go from query to calendar nearly instantly! Create web pages with calendars for each month from your data in Access ... it just doesn't get any easier!

PDF option coming ...

Steps

Make a Query to show what you want for the calendar

Make sure it has a date that is sorted called CalDate. Other information (CalTitle, Text1, Text2, Text3) is optional.
Copy the Query name to the clipboard
- in the Navigation Pane, select the query when it is closed and press F2 to rename, or right-click and choose Rename from the shortcut menu. Press Ctrl-C to copy the name.
Run the test_3_Create_HtmlCalendar_AskQueryName function (or the mcr_CALENDAR-From-Query macro).
when prompted, paste the Query name from the clipboard using Ctrl-V.
Look at your finished calendar!

Logic

Create Calendar

Set array of colors to use
Set the column width for each day
If the specified query has parameters, prompt for them
OpenRecordset with the data (must be sorted by date)
See what fields are specified
1. CalDate: calendar date is required
2. CalTitle: optional, read from first record
3. Text1: optional, first text in cell
4. Text2: optional, second text in cell
5. Text2: optional, third text in cell
Figure out year and month for calendar.
Determine filename.
Determine path.
Open or create a file and write the HTML to make the calendar.

Open file or folder

If one calendar report was made, then open it. If more than one report was made, then open the folder (this feature is coming)

Look at the code

Click to view the code for the HTML Calendar Report

Macros

Someone who has Access 2007 emailed me. He thinks the calendar is awesome, and was able to import the module ... but the macros wouldn't come in. Thanks for writing, Stephen. Here is the logic so that you can make your own macros:

mcr_CALENDAR-From-Query

RunCode

=test_3_Create_HtmlCalendar_AskQueryName()

mcr-OpenCalendarFolder

RunCode

=OpenCalendarFolder()

Download

HTML_Calendar_s4p_ACCDB.zip (112 kb, unzips to Access database)

mod_HtmlCalendarReport_s4p__BAS.zip (7 kb, unzips to BAS file)

To use this code, import the module into your working database (and then compile and save, of course).

There is a macro in the sample database that asks for a query name and then, presto, calendar!

Alternately, a quick way to show the calendar using VBA is:
Application.FollowHyperlink Create_HtmlCalendar (sQueryName)

This will open a web page with the calendar created from the query name stored in sQueryName.
The Create_HtmlCalendar function creates the calendar as an HTML file (web page) and returns the path and filename when done.
You have a calendar file you can email and share with others.

License

The Calendar Report may be used freely, but you may not sell it in whole or in part. You may include it in applications you develop for others provided you pass on the download link and share the source code and designs with your modifications.

Video

Video Tutorial

How to Create Calendar Reports from Access Queries with dates! ... as shareable Web Pages

Watch on YouTube

CLICK the ARROW in the middle of image to watch the video

video showing how to create Calendar reports from Access queries with dates

References

Database.OpenRecordset method (DAO)

Docs / Office client development / Access / Access desktop database reference / Microsoft Data Access Objects reference / Database

Help: Database.OpenRecordset method

FreeFile function

Docs / Office VBA Reference / Language reference / Reference / Functions / FreeFile

Help: FreeFile function

Open statement

Docs / Office VBA Reference / Language reference / Reference / Statements / Print #

Help: Open statement

Print # statement

Docs / Office VBA Reference / Language reference / Reference / Statements / Open

Help: Print statement

Close statement

Docs / Office VBA Reference / Language reference / Reference / Statements / Close

Help: Close statement

Back Story

It is always easier to see information graphically, and what better way than a calendar for dates? HTML is nice because the web page files are easy to share and look at. There is an option to print to PDF files coming!

Share this page with others

here's the link to copy:

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

Do you have code or tools to share?

Are you a developer? If you have good stuff to share, or perhaps already have pages with content that others can visit, email me! Ask how to get your stuff added to the code or tools index for everybody. info@msAccessGurus.com

When we communicate, collaborate, and appreciate, we all get better.

Do you have something to say?

It is my hope that you build great applications with Access, design your database structure well, link to and share with data in other formats, and use other Office applications such as Excel, Word, and PowerPoint, ... take advantage of built-in abilities, use strengths of each product, and manage your information wisely.

It is nice to hear from you. Some of you write to say thanks and tell me what you're doing with Access, -- I love to hear about that! Sometimes, you write because you found a bug, are confused, or want this to do more. Email me at info@msAccessGurus.com ~crystal

Get Help

Do you want a menu? translate the calendar to another language? change the first day of the week to be Monday? ... or whatever day you like? put more on each day? use conditional formatting to determine colors? change paper size for printing? print calendars for a range? specify other criteria?

This is a starting point. If you want to go further and need help, email me. I'm happy to help.

Free Book to Learn Access

Access Basics

Free Video Tutorials

Learn Access Playlist

Quick Jump To Sections

Screen shot

Get a Calendar showing whatever you want, like important dates for jobs you are working on.