create a gantt chart using Access 2007

[SpiritedAway]

Hello Everyone

Is there a way of creating a gantt chart in an Access 2007 form- either through Macros or VBA. I prefer not to use Third-Party software if possible.


Thanks for any Insight on the matter

 

[georgedwilkinson]

Gantt charts and project management are very complex and the market has already been (more than?) satisfied with the products that exist. No need to go through so much effort for so little reward.

 

[Rich]

Don't know if it works in 2007.........but
http://www.access-programmers.co.uk/forums/showthread.php?threadid=41357&highlight=gantt

 

[SpiritedAway]

I understand the market is jammed with project software - I'm not trying to recreate or reinvent the wheel in that respect but I would like to create the chart in an Access form as all the data i need sits in a relational db and it would suite the database to create a simple chart to illustrate the progress thus far....

Rich, thanks for posting the link, I'm downloading it onto my home pc, Access 2003 but it jams on opening to the VBA code of the db, saying compiling error, etc... I will work around this and see how the rest of the db is constructed. I'll take it to work and try it out on Access 2007 there....

What i have seen of it so far- looks pretty impressive and thanks for the support. I will let you know how I get on.

 

[georgedwilkinson]

Please do let us know. I know that you can use Office automation to embed MS Project objects in Access but it would be nice if there were an option with a little lower license cost.

I like the handle, btw. Are you into Miyazaki? Some of the best anime out there IMHO.

 

[SpiritedAway]

Yes, very big fan of Miyazaki - he is the master of simplicity but beneath which lies a whole other world.

You make an interesting point about automation between Project and Access, there is a ton of information about automation between Access and Excel, Word and Outlook but very little about Project. I thought Access didn't support Project file format and that extended to its controls.

If, Access can automate with Project, any thoughts, suggestions or sample databases about where I can learn more would be welcomed.

 

[boblarson]

If, Access can automate with Project, any thoughts, suggestions or sample databases about where I can learn more would be welcomed.

Yes, Access can automate with Project.

I think starting with something like this book to get familiar with the objects in Project would be the place to start. Then you can do just like any other Office Automation

Dim projApp As Object

Set projApp = CreateObject("Project.Application")

etc...