How do I create a Gantt chart?

[Guest]

I want to generate a Gantt chart from data in tables or queries. I want the
Gantt chart either on a form or in a report.

 

[Tim Ferguson]

I want to generate a Gantt chart from data in tables or queries. I
want the Gantt chart either on a form or in a report.

MS Project has an OLE automation interface, doesn't it?

Tim F

 

[Duane Hookom]

There is at least one sample that might help you in the calendar reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. There is a crew
rotation schedule report. Most of the other reports use code to place and
resize text boxes (time bars) based on data values.

 

[Guest]

Hi Tim

Thanks for the advice. For me, MS Project would be an expensive option for
obtaining a lot of enhancements.

Dan

 

[Guest]

Hi Duane,

Thank you very much. That is very helpful. If I had a big budget, which I
don't, no doubt I could buy software that might interact, etc. Your
information is very useful. I was heading in the direction of placing and
resizing text boxes based on data values as a solution. Thanks for taking the
time to write.

Dan