Timeline chart in Access

[AdminAmber]

Hi-

Most people who want timelines use Microsoft Project. However, some people
here find it difficult to use Project and they also don't think the timelines
in Project come out looking "pretty". They want to use Access so that they
can use the user-friendly forms to update and change data, and so they can
manipulate the visual appeal of the report.

If I have a listing of rigs and start dates/end dates of when they are
online, is it possible to get a timeline graph like I would see in Project?
We have switched to 2007, but have old versions of 2003 if needed.

 

[Duane Hookom]

There is an example of how to create timelines in reports in the Calendar
Reports sample at http://www.access.hookom.net/Samples.htm. You can make the
bars look however you want.

 

[AdminAmber]

Duane-

Thanks for your reply. I downloaded your example and looked at the Ship
Rotation Schedule chart, and its exactly what I'm looking for. I'm confused
how to create the bars at all. I looked in the code (Report_rptRotation) and
tried to work backwards. I assigned a color to each activity in my activity
table. I also change the DateDiff to #1/1/2008#. I tried changing anything
in the code that referenced another table or field to the correct names from
my database, and its not working. The report kept prompting me for "vessel"
when I tried to run it, and I couldn't find where this prompt is coming from.
Please let me know if I can provide you with any other information to help
clarify my problem.

 

[Duane Hookom]

I think the "Vessel" is most likely in the Sorting and Grouping dialog. You
would need to select a sort/group by your specific field.