Write HTML using VBA

HTML Calendar Report

it just doesn't get any easier ...
go from query to calendar nearly instantly

Quick Jump To Sections


Get a Calendar!
From a Query


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)


The Calendar Report may be used freely provided you do not modify it and sell it. You may include it in applications you develop for others provided you pass on the download link and share the source code. It is licensed to you under CC BY-NC-SA 3.0, ' Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported

Look at the code

Click to view the code for the HTML Calendar Report

Goto Quick Jump

Video Tutorial

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

video: How to Create Calendar Reports from Access Queries ... as shareable Web Pages - easy! (cc)


Free Book to Learn Access

Access Basics

Free Video Tutorials

Learn Access Playlist


Do you like this tool?

Do you need help with an Access project?


© Copyright 2017 Crystal Long.  All rights reserved.
Last Updated:  August 2017