Home  |  About  |   Search   

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

RunCommand Constants

Terms of Use


 

Reports: Displaying timelines on a report

Author(s)
Dev Ashish

   If you have a StartDate and an EndDate stored in a table and want to display a MS-Project like timeline on an Access report, you'll have to write code.

    One way to accomplish this is to use a rectangle's dimension as a baseline.  The maximum width of the rectangle will denote the difference between the maximum values of StartDate and EndDate respectively.  Then if you have another rectangle which will shrink/grow to match the dates, you can align the control using it's Left property and give it a  computed width using the baseline rectangle for measurements.

    Download TimeLines.Zip sample database for an example.


1998-2009, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer