access query that uses visio to draw data link analysis flowchart

[John Luquer]

I would like to have the ability to create a query that pulls data from a
table in a format that enables visio or as an access report to automatically
create a flowchart from inside access. This would enable me to see
associations in my data. I can do something similar by exporting into a comma
del. excel spread sheet and imoprting into RFFlow but this is time consuming
and troublesom.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...6aa9&dg=microsoft.public.access.modulesdaovba

 

[TC]

You want to pull data from a table as an Access report to automatically
create a flowchart?

I have hundreds of tables in dozens of databases, but I have no idea
what it would mean to "create a flowchart" from any of them!

You'll have to be clearer in what you require. Remember - we have /no
clue/ what you are talking about, except for what you write in your
post. There is no auomatic or common sense relationship between tables
and flowcharts, which would let us guess what you want.

HTH,
TC

 

[RD]

You want to pull data from a table as an Access report to automatically
create a flowchart?

I have hundreds of tables in dozens of databases, but I have no idea
what it would mean to "create a flowchart" from any of them!

You'll have to be clearer in what you require. Remember - we have /no
clue/ what you are talking about, except for what you write in your
post. There is no auomatic or common sense relationship between tables
and flowcharts, which would let us guess what you want.

HTH,
TC

I seem to recall that in some past iteration, Access and Visio could talk to
each other. I could design a database in Visio and import the flowchart like a
schema into Access. In the other direction, I could export the relationships of
an existing db into Visio which was nice for documenting the project.

I wish MS hadn't eliminated that functionality. I kinda miss it.

 

[John Luquer]

To clerify: If I have 100 records in my db that contain 2 names a field
containing a type of relationship is say "confirmed or suspected etc" per
record and create a query that pulls names and relationship. In one record
john and mary and confirmed are there. In a differant record Mary and Steve
and suspected are there. I would like to create a link Analysis diagram
(flowchart) like the auto form function that creats an object say a circle
for each name and draws a line (solid for confirmed relationships and dashed
for suspected relationships) connecting the circles. in the stated example
above if John were centered in the diagram the cirle labled John would have a
line to Mary who would have a line to Steve. If Mary were centered in the
diagram That circle would have a line to John and Steve.

 

[Tim Ferguson]

I seem to recall that in some past iteration, Access and Visio could
talk to each other. I could design a database in Visio and import the
flowchart like a schema into Access. In the other direction, I could
export the relationships of an existing db into Visio which was nice
for documenting the project.

I wish MS hadn't eliminated that functionality. I kinda miss it.

That was Visio Enterprise edition: for all I know it still does it.

There are any number of ER modelling programs on the market, some
expensive and some cheap, and most of which will read and write to a jet
mdb. Have you tried googling? These come to mind:

http://www.modelcreator.com/index.php?s=content&p=analyzer

http://www.embarcadero.com/products/products.html

but there are lots more.

Hope that helps


Tim F

 

[RD]

That was Visio Enterprise edition: for all I know it still does it.

There are any number of ER modelling programs on the market, some
expensive and some cheap, and most of which will read and write to a jet
mdb. Have you tried googling? These come to mind:

http://www.modelcreator.com/index.php?s=content&p=analyzer

http://www.embarcadero.com/products/products.html

but there are lots more.

Hope that helps


Tim F

Ah! That would explain why I haven't seen it in a while. I haven't had
Enterprise Edition in a long time.

Thanks for those links, Tim. Both products look very interesting.

Regards,
RD