access query that uses visio to draw data link analysis flowchart

MS Office Access

    Sponsored Links

    Next

  • 1. Fast Data Saving
    I'm looking for fast way to save the whole table from my program in MS Access. Doing it row by row works slowly in ADO.NET. My current program does it using DAO with C++. I'm looking for a solution that will work with 64-bits.
  • 2. Variable Field(control) name
    What I'm trying to do seems like it should be simple, but I can't seem to get the syntax right. I have a form that has several controls on it that are linked to fields in a table. Depending on what the user is doing I just need to populate the right field(control) with a date. dim fieldname$ fieldname = A, B, C, D, or whatever Forms![FormName](fieldname) = Now Any help on this would be greatly appreciated. TIA

access query that uses visio to draw data link analysis flowchart

Postby Sm9obiBMdXF1ZXI » Thu, 05 Jan 2006 07:43:30 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.

----------------
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.**--****.com/ 

RE: access query that uses visio to draw data link analysis flowchart

Postby Sm9obiBMdXF1ZXI » Fri, 06 Jan 2006 22:40:02 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.




Similar Threads:

1.access query that uses visio to draw data link analysis flowchart

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

2.Drawing a flowchart from Access tree (parentID) data



Return to MS Office Access

 

Who is online

Users browsing this forum: No registered users and 14 guest