how to graphical visualize simple PERT chart (network planning)

[Koen]

Hi all,

Is there any example code available somewhere that graphical visualizes a
simple network planning (PERT chart)?

I have two tables:

tblAction:
ActionID (PK)
Description
StartDate
EndDate

and tblActionLink:
Predecessor_ActionID (PK, FK)
Successor_ActionID (PK, FK)

So, one action could have multiple predecessor actions and multiple
successor actions.

This is part of an application I wrote where I do some simple planning of
actions. What I did now, is show a parent subform and a child subform to
show all the predecessors and successors of a particualar action.

The problem is that this doesn't give the user the overview it needs: a
simple graphical network diagram (PERT chart).

Is such a thing possible?

Kind regards,

Koen

[Larry Linson]

You'd be better off with project management software (e.g., Microsoft
Project, Primavera, etc.) that already does this. I assume you are talking
about a GANNT chart. A quick Google search on GANNT turns up a free chart
builder on the first page.

There have been hints that a GANNT chart was going to be included in the
charts that you could create from Access, but it still hasn't turned up. If
you have Excel installed, you can create a GANNT with Excel, and you can get
the data from an Access/Jet database.

Larry Linson
Microsoft Access MVP

"Koen" <[e-mail]> wrote in message
news:Xn*********************@194.109.133.20...

Hi all,

Is there any example code available somewhere that graphical visualizes a
simple network planning (PERT chart)?

I have two tables:

tblAction:
ActionID (PK)
Description
StartDate
EndDate

and tblActionLink:
Predecessor_ActionID (PK, FK)
Successor_ActionID (PK, FK)

So, one action could have multiple predecessor actions and multiple
successor actions.

This is part of an application I wrote where I do some simple planning of
actions. What I did now, is show a parent subform and a child subform to
show all the predecessors and successors of a particualar action.

The problem is that this doesn't give the user the overview it needs: a
simple graphical network diagram (PERT chart).

Is such a thing possible?

Kind regards,

Koen

[Pieter Linden]

One way of doing PERT charts is to umm... use MS Project? You can
stuff whatever you want into Access, and then have it write everything
to Project and do the PERT chart there... It's kinda pricey, though...
You can also do PERT charts with Visio, but it's probably easier in
Project...