Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / November 2007

Tip: Looking for answers? Try searching our database.

Help I'm stuck - Custom Reports

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mizu001 - 01 Nov 2007 06:13 GMT
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 - 01 Nov 2007 15:24 GMT
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.

Signature

Duane Hookom
Microsoft Access MVP

> Hi All
>
[quoted text clipped - 17 lines]
> Cheers
> Mizu
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.