Help I'm stuck - Custom Reports

[Mizu001]

Hi All

I am writing a small database application to create my family tree. I know
there are many commerical software and websites providing this functionality
but this is also a learning project to teach myself some programming.
I have the tables, data entry forms done. I am now trying to build a report
with a descendent tree that looks like an organizational chart. I would like
this chart to show all the family members (current data) I have inserted
everytime I run this report from within my application.
I tried playing with inserting a visio document control activex but I was
only able to paste the visio file I had created in Visio 2003. I'd like to be
able to do programatically create this chart from inside my application
instead of first updating in visio and then copy pasting it from visio
everytime.
Is there a way to do this?

Any help/directions/pointers would be greatly appreciated. My apologizes if
this same question has been asked many times before.

Cheers
Mizu

 

[Duane Hookom]

Creating an organization chart in an Access report would be no small task. If
you only had a couple generations and a small family, you might be able to do
this if you really understand report coding with .MoveLayout = False and the
Line method. If you have many generations and large families you would need
to determine how to divide small and large branches across multiple pages and
get the spacing and sizing correct.

Vision does have a version that supports pulling records from Access to
create org charts.