Org Charts

[Guest]

Is there anyway to make an org chart with Access? I've made some pivot type
charts. If I'm storing a bunch of information on various Access and Excel docs
and want a chart to show where the data is coming from and going to, what the
best way to store this? Do I need visio? Or To record making a chart in
powerpoint, then make a powerpoint obj var and some how run text stored for
each document that will send the macro into Powerpoint? Are there any active X
controls?

We're storing size, user, type, name, path, function, sourece, destination, etc
in common table fields. But what do I do when I need to store org charts.
Possibly hundreds? Link to real org charts in a folder? Record code to store
it?
It would be too time consuming to make some textboxes on a form and makeshift
arrows, then store the number, top, left, height, width, and text in them for
each doc, though it could be done theoretically. Storing them all in fields for
each doc that needs a chart.

Any ideas?
(e-mail address removed)

 

[Duane Hookom]

Some versions of Visio will allow you to create Org Charts from a table in a
database. If I recall correctly the table/query should include the
SupervisorName in the record of the employee information.

 

[Guest]

That could be interesting. I guess I would only need one org chart and use the
databse to maniupulate it based on choices from a user control or something.
Thanks. I'll look into that. I think Visio is VBA compliant.
(e-mail address removed)