Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Long, Crystal
  New Posts New Posts RSS Feed - Calendar Report in HTML format
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

Calendar Report in HTML format

 Post Reply Post Reply
Author
Message
Crystal Long View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 21 May 2012
Location: Colorado
Status: Offline
Points: 35
Post Options Post Options   Thanks (0) Thanks(0)   Quote Crystal Long Quote  Post ReplyReply Direct Link To This Post Topic: Calendar Report in HTML format
    Posted: 05 Jul 2012 at 11:31am

download:
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

Feedback is appreciated, thank you

Warm Regards,
Crystal

Microsoft MVP
remote programming and training

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

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 ~
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.