Print Page | Close Window

Calendar Report in HTML format

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Long, Crystal
Forum Description: Access Basics is designed for those of you with a thirst to understand the fundamentals of Access with programming in mind ... whether you realize it or not.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=599
Printed Date: 28 Mar 2024 at 5:05pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: Calendar Report in HTML format
Posted By: Crystal Long
Subject: Calendar Report in HTML format
Date Posted: 05 Jul 2012 at 11:31am

download:
uploads/84/Calendar_Report_HTML_060517_Crystal.zip - uploads/84/Calendar_Report_HTML_060517_Crystal.zip
explodes into an Access 2000 database, Word doc, and a ReadMe text file.
  • MDB file uses an ActiveX control that was depreciated in Access 2007 -- note on how to fix at bottom.
  • DOC with all the code-- function is very flexible, you can call it from your own code
  • ReadMe....txt with this link

Calendar Report in HTML format - easy to create and share!

create a calendar from any table or query!

The easiest way to use this tool is to use a query to line up the data you want on the calendar.

Flexible menu form to slice and dice your data a number of ways to display on a calendar.  Creates a web page with your calendar so you can share it with anyone !

Show Qty for each record or sum it

calendar report showing Summed information

Change Colors

change colors on the calendar

calendar showing colors

set multiple fields to display in the description area

set 2 fields to display in the description area

report showing 2 fields in description and sum Qtry

change Format code to show thousands of dollars with no decimal

change Format code to show thousands of dollars with no decimal

calendar report showing formatted data

calendar report showing formatted data

Choose from Tables or Queries -- and simply double-click to open if you desire :)

Show SQL for Queries


show SQL for query, double-click to open

NOTE:

this is an MDB file that uses an ActiveX control that was depreciated in Access 2007 in the PickDate form, which pops up when a date control is double-clicked.

If you are running in a higher version:
1. convert to an ACCDB
2. delete the form --> PickDate
3. import f_PopupCalendar form*
4. rename f_PopupCalendar to --> PickDate (or change the property sheet/code)

Related Tool:

* Popup Calendar
by Crystal
on RogersAccessLibrary
http://www.RogersAccessLibrary.com/forum/popup-calendar-for-access-2007-and-above_topic597.html - http://www.RogersAccessLibrary.com/forum/popup-calendar-for-access-2007-and-above_topic597.html

Feedback is appreciated, thank you

Warm Regards,
Crystal

Microsoft MVP
remote programming and training

Access Basics by Crystal
http://www.AccessMVP.com/strive4peace - http://www.AccessMVP.com/strive4peace
Free 100-page book that covers essentials in Access

http://www.YouTube.com/LearnAccessByCrystal - http://www.YouTube.com/LearnAccessByCrystal

 *
   (: have an awesome day :)
 *




-------------
Warm Regards,
Crystal
Microsoft MVP
Remote Training & Programming
Let's Connect and Build Together

http://www.AccessMVP.com/strive4peace
http://YouTube.com/LearnAccessByCrystal
~have an awesome day ~



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net