Timeline - Bar Chart for Planning

[vmo13]

Good Morning/Afternoon All,

I am a newbie in Access thus pardon me if I am unclear.
I have several databases built and a final query that list :
Project Name, Analyst assign, Planned Start Date, Planned end date.
I am trying to find a form/report that could show me on a monthly/bi monthly schedule (only showing weeks and not days) "who is doing what"
Ideally I am looking for a table where I would have on the Y Axis the week; the X axis the Analyst, and the table will be populated with bars with the name of the project on it; the bar size would depend on the duration of the project (so a level one gantt chart).
I have seen many example on the web; but nothing really that match my needs. I already saw Duane Hookom example on boat rotation(http://www.access.hookom.net/Samples.htm) but was not successful to modify it.
Does someone have an update version of Duane Hookom example of the boat rotation report or something similar?

Thanks,

[zmbd]

1) I didn't see anything right off the bat in the link you provided that appeared to relate to your question. I might have just overlooked it?

2) it appears that gnatt charts are not a native tool for Access (seems strange; however, not uncommon for MS to not provide something common for business)

!) keep in mind I'm only offering a potential solution. I haven't tried any of the following:

3) you could try automation to push data out for Outlook, Project, Excel, etc...

4) in Access the stacked bar type graph is also available so you might be able to do something along these lines within Access... should be able to do it with just a query so no VBA would be needed: Create a Gantt chart in Excel. Once the chart is in the report/form you would right click and open the chart object where you can select the stacked type bar graph, formatting etc...

5) VBA and a ton of it.
Time Line Display

6)/..../ I may update this if I run across something else.

[Mariostg]

I can't see the link you provided from where I am.
In the past I've done it through VBA which would create HTML(table tags with colspans) or SVG. Access would create the file in question then fire up IE. If you are familiar with any of those (and wants to learn VBA) you can get pretty fancy. Throw in some good CSS and javascript and sky is the limit. First build your html view as a prototype then code it in VBA.

I'm pretty limited as to what I can use here. We are still on IE 7 and I can no longer use SVG...