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 / Modules / DAO / VBA / January 2006

Tip: Looking for answers? Try searching our database.

access query that uses visio to draw data link analysis  flowchart

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John Luquer - 03 Jan 2006 22:43 GMT
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.
TC - 04 Jan 2006 09:26 GMT
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 - 04 Jan 2006 23:39 GMT
>You want to pull data from a table as an Access report to automatically
>create a flowchart?
[quoted text clipped - 9 lines]
>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.
Tim Ferguson - 05 Jan 2006 17:38 GMT
> 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
[quoted text clipped - 3 lines]
>
> 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 - 06 Jan 2006 16:19 GMT
>> 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
[quoted text clipped - 19 lines]
>
>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
John Luquer - 05 Jan 2006 13:40 GMT
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.

> 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
[quoted text clipped - 11 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=c91312c6-31ef-4
1e8-974f-b791550c6aa9&dg=microsoft.public.access.modulesdaovba
 
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.