by Axel Womatschka (3 Submissions)
Category: OLE/COM/DCOM/Active-X
Compatability: Visual Basic 3.0
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: (31 Votes)
Visualize Time or Date Ranges in a chart ! Noe its very easy to create, for example, Holiday Charts. If you want to display Time or dateranges in a graphic, this is the OCX for you.
Inputs
A Access Database (Access 97 or higher, other Access versions may work too, but not tested). A table with Dateinformations (Start- and ending date); setting the Colors and Caption as you wish to design the Layout.
Assumes
A Demoprojekt with a test Database is included.
Code Returns
A chart (timeChart).
Side Effects
Because the OCX displays a full year as 52 weeks, the OCX seoerates the year into 4 Quarters. You only have to set the year and a quarter. Everything else the OCX calculates automatically. You only have to set the tablefields of the startind and ending date you wish to display.
Download TimeChart (15 KB)