Can you use Access VBA to represent logical relationships in graphical form? (1 Viewer)

Harry Paraskeva

Registered User.
Local time
Today, 18:45
Joined
Sep 8, 2013
Messages
67
This is an exploratory question rather than one that help is needed. The title pretty much covers the question, but an example might help:

The situation is one where I have box numbers/names stored in a table (e.g. Box 1, Box 2, Box 3, etc.) and the spatial relationships between boxes in another table (e.g. Box 1 is above Box 2, Box 3 is next to Box 2, etc).

Would it be possible to write a module or piece of code in VBA that produces a graphical representation of the boxes and their relationships with lines connecting the boxes that share one such logical relationship?
 

Ranman256

Well-known member
Local time
Today, 11:45
Joined
Apr 9, 2015
Messages
4,339
I used Microsoft Visio to do this. You build a table with who is the manager of who,
name, manager
sam, bob
gale, bob
bob,
gary, sam

you can use a function or vb to build the org chart in Visio. Excel still doesnt work well with it.
 

Users who are viewing this thread

Top Bottom