how to build a Gantt Chart in Form

[Haroon]

hi

i want to build a gantt chart in form to show project progress status,
in the table 'project status', i have project name, project manager, start
dates and end dates,

anyone knows how i can show this as a gantt chart view?

thanks.

 

[Peter Hibbs]

A Flex Grid Control will probably do what you want but you will need
to write a bit of VBA code, have a look at my Flex Grid Demo program
for some examples.

Go to http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

HTH

Peter Hibbs.

 

[Haroon]

thanks that helps,

it is too complicated to understand and make one from scratch,
is there a simple and basic way of creating it?

thanks.

 

[Peter Hibbs]

Haroon,

Sorry, there is no Wizard that can build an application using a flex
grid control. If you do not have the Visual Basic knowledge to write
the code yourself I can only suggest paying a developer to do it for
you. There are many companies around that could do that, such as
http://www.rptsoftware.com/ for example, but I have no idea how much
they would charge for such a project.

Perhaps now would be a good time to learn VBA, there are a few good
tutorials on the Internet and many books as well.

Good luck with your project.

Peter Hibbs.

 

[Haroon]

hi hibbs,

how can i extent the flex grid to show more months or full month? also can i
add zoom buttons on it to zoom out to see whole year view?

thanks.

 

[Peter Hibbs]

You could certainly write code to change the flex grid display to show
months and/or years, it would obviously depend on what exactly you
want to show and whether it could fit on the screen.

I have another flex grid demo which shows all the months of the year
as a calendar with each day colour coded for various categories, etc.
It also shows the months, weeks and days in a similar way to the demo
at the Web site I mentioned. If you would like a copy of that just
email me at the email address in the documentation and I will send you
a copy. I should mention though, that the code is quite complicated
and not really a project for a beginner.

HTH

Peter Hibbs.