Drawing a flowchart from Access tree (parentID) data


    Sponsored Links


  • 1. How To Color Fill A Closed User Defined Shape
    I created some (apparently) closed irregular shapes by connecting segments into a loop using the Line Drawing tool. But I can't color fill the shape. Can someone tell me how that's done?
  • 2. How to paint connections by value
    Hi, Im doing rack diagram, so i need to paint all cables with different colors by their lengths. I can see all connections lengths from "size & position" one by one, How to do that? now looking up that "color by value" command and it doesn't work? Pls help?
  • 3. Print Correct Page Number
    I have a Visio 2003 file with foreground footers on 3 pages. If I print all pages, I get the correct footers, page 1 of 3, page 2 of 3, etc. However, if I print just page 3, it comes out as page 1 of 1. How do I get it to print the correct page number and total pages? Thanks in advance!

Drawing a flowchart from Access tree (parentID) data

Postby Nick Mirro » Sun, 28 Dec 2003 12:32:39 GMT

I have Visio and Access 2002.  In Access, an evolutionary tree is
represented in several tables using NodeNames, NodeIDs and ParentIDs.  The
link below shows the relationships.

 http://www.**--****.com/ ~nickmirro/images/Temporary/Relationships.JPG

1. Is it possible to have Visio 2002 or 2003 (standard edit.) automatically
draw a flowchart type tree structure using these tables or queries?

2. If so, can I ask how?

3. Are there any writeups on how to do this?

(optional extra info)

Imagine the tree is upright in this description (parents are down).  Each
node in the tree (except the few at the very bottom - trunk portion) has
assigned to it a parent node by the identifier, ParentID.  This creates a
sequential hierarchy below each childmost terminal (leaf) node in the tree.

Re: Drawing a flowchart from Access tree (parentID) data

Postby Nick Mirro » Mon, 29 Dec 2003 08:16:35 GMT

Will the pro version do this without extensive coding?


Re: Drawing a flowchart from Access tree (parentID) data

Postby Nick Mirro » Thu, 08 Jan 2004 05:33:40 GMT

Thanks for your help with this.  Do you mean the pro version will draw the
relationships diagram?  I was hoping to generate an actual organizational
type chart based on the data in these displayed tables.




Re: Drawing a flowchart from Access tree (parentID) data

Postby RA » Sat, 10 Jan 2004 08:36:16 GMT

The Pro version will draw the table relationship diagram.
e.g. Table1 inherits from Table2 and so Visio will draw a connection between
Table1 and Table2.

 http://www.**--****.com/ ~nickmirro/images/Temporary/Relationships.JPG

Similar Threads:

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

2.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.


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

4.Visio linked to Access - edit Access Data from within Visio

I have a map made in MS Visio which is linked to an MS Access database. Each 
item in visio contains a serial number which is linked to serial numbers in 
the MS Access Database. Each 'shape' is linked. The access database is about 
40 columns of data per serial number which is tied to the shape. I need to be 
able to edit the data from within Visio. 

If I edit the shape data, it doesn't make the modifications to the access 
database, but does maintain the change in the shape data until I refresh the 

How do I make the changes in visio shape data record to the access database? 

5.How do you access data from a Access Database from Visio using

Thanks! I'm an apprentice to VBA, therefore I was only able to follow certain 
segments of this code. When you program Visio do you always have to have data 
in the user-defined cells and the custom properties? The reason I ask is 
because I have neither. I have a drawing that I created and I want to 
retreive information from the database based off of doulble clicking that 
particular shape! Is that possible? Thank you in advance!

"Al Edlund" wrote:

> you might try something like this
> ' this is used by the cell changed event to allow us to just change a
> ' single cell in a record, rather than full record updates. work in
> ' progress
> Public Sub subDiscreteFieldUpdate(strTable As String, strIndex As String, 
> strGUID As String, strField As String, strValue As String)
> Dim intResult As Integer
> Dim str_db_filename As String
> Dim db As Database
> Dim visDocument As Visio.Document
> Dim visPage As Visio.Page
> Dim SaveErr As Long
> Dim errDB As ADODB.Error
> Dim cnn As New ADODB.Connection
> Dim rst As New ADODB.Recordset
> Dim strProvider As String
> Dim strSource As String
> Dim strConn As String
> Dim strSelect As String
> strProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
> strSource = "Data Source="
> Dim strProviderED As String
> strProviderED = ";"
>         On Error GoTo DiscreteField_Exit
>         'first we have to find out which database is associated with this 
> document
>         Set visDocument = Visio.ActiveDocument
>         Set visPage = visDocument.Pages.item("Project Definition")
>         str_db_filename = visDocument.Path & 
> visPage.PageSheet.Cells("prop.database_file.value").ResultStr("")
>         strConn = strProvider & strSource & str_db_filename & strProviderED
>         cnn.Open strConn
>         strSelect = "SELECT * FROM " & strTable & " Where " & strIndex & " = 
> " & strGUID
>         rst.Open strSelect, cnn, adOpenKeyset, adLockOptimistic
>         If (rst.BOF And rst.EOF) Then
>             ' Debug.Print "err discrete field update " & strGUID & " record 
> not found"
>             GoTo DiscreteField_Exit
>         End If
>         ' MsgBox strValue
>         If strField = "propcost" Then
>             ' Debug.Print "propcost " & Int(strValue)
>             rst.Fields(strField).Value = Int(strValue)
>             Else
>                 rst.Fields(strField).Value = strValue
>         End If
>         rst.Update
> DiscreteField_Exit:
>         rst.Close
>         cnn.Close
>         DoEvents
> Exit Sub
> DiscreteField_Err:
>   SaveErr = Err.Number
>     If SaveErr <> 0 Then
>         Debug.Print "Err in subDiscreteFieldUpdate is " & Err & " " & 
> Err.Description
>         Debug.Print strGUID & " " & strField & " " & strValue
>         For Each errDB In cnn.Errors
>             Debug.Print "DB Update " & " " & strGUID & " " & strField & " " 
> & strValue
>             Debug.Print "DB Description: " & errDB.Description
>             Debug.Print "DB Number: " & errDB.Number & " (" & _
>                 Hex$(errDB.Number) & ")"
>             Debug.Print "JetErr: " & errDB.SQLState
>         Next
>         ' Resume DiscreteField_Exit:
>     End If
> End Sub
> "Vondre Daniel" <Vondre  XXXX@XXXXX.COM > wrote in message 
> news: XXXX@XXXXX.COM ...
> > I'm using Visio 2002 and I want to double-click on a shape in the drawing
> > and have it query an Access Database for specific information.  I'm not 
> > sure
> > how you set up the connection string in vba to the database. I need this 
> > to
> > work for an internal and external database. I've been trying to write code 
> > in
> > vba an place that function/procedure in shape's shapesheet under the 
> > events
> > group.  Can someone please assist in this tasks. Thanks! 

6. How do you access data from a Access Database from Visio using VB.

7. Visio Timeline in MS Access 2003 Data Access Page

8. Accessing data from a Access 2000 workspace with Visio 2002

Return to VISIO


Who is online

Users browsing this forum: No registered users and 56 guest