MS Org Chart

[J. Raddatz]

Hello,
I want to display the organization of my access 2000
database in Power Point 2000 with the help of the org
chart utility. Due to the fact my database design is still
changing I want to do this via code in VB. So whenever my
database design changes I want the VB code to create a new
org chart.

Problem is I dunno how.
Can you please give my an idea where and how to start?
I would need to know how to create an org chart object in
VB and how to manipulate it.

Thanks a lot in advance
Greetings
Jan

 

[???? ?? ?????]

hei

 

[J. Raddatz]

ok a little confusing maybe.
What I tried to ask was:

How do I write a VB macro in MS Access 2000 that starts up
Power Point 2000, Creates a new slide and then creates a
Microsoft OrgChart Object.

After creating the orgchart Object I need to be able to
manipulate it via code.

My aim is to display the relations between tables in my
database via this orgchart in the end.

Thanks in advance
Jan

 

[Arvin Meyer]

ok a little confusing maybe.
What I tried to ask was:

How do I write a VB macro in MS Access 2000 that starts up
Power Point 2000, Creates a new slide and then creates a
Microsoft OrgChart Object.

After creating the orgchart Object I need to be able to
manipulate it via code.

My aim is to display the relations between tables in my
database via this orgchart in the end.

Not knowing the PowerPoint object model very well, I can't write the code
for you, but I would wonder why you are interested in doing this when Access
has the ability to display relationships built write into the application?
With the database window displayed, go to Tools ... Relationships.

Then use the Relationships menu came to "Show All" Then choose File ...
Print

and your done. Or you can easily show 1 table at a time and show the
relationships to that table. If you really want PowerPoint slides, to a
screen capture.

If you really want to do the is PowerPoint in the manner you suggested, open
a code window then set a reference to PowerPoint. From the View menu open
the Object Browser, select the PowerPoint library and familiarize yourself
with the object model. You can probably then use one of the Microsoft
PowerPoint newsgroups to get help on specific questions.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[J. Raddatz]

Hi Arvin,
thanks for your help.
I do know the relationships window in Access. I need Power
Point for a presentation and I can not use access for it.
That's why I need to know more about the OrgChart object
modell. I can't find any documentation on it but I know it
is possible to programmatically access and organisation
chart and to edit it.

Thanks
Jan

 

[Arvin Meyer]

Hi Arvin,
thanks for your help.
I do know the relationships window in Access. I need Power
Point for a presentation and I can not use access for it.
That's why I need to know more about the OrgChart object
modell. I can't find any documentation on it but I know it
is possible to programmatically access and organisation
chart and to edit it.

Make a screen capture. I use SnagIt

http://www.techsmith.com/products/snagit/

because it allows me to get areas of the screen, but Alt+PrtScn and Paint
works too. I use the resulting image in PowerPoint.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access