'Add top level node (is not a child of any node) 'Set nAdd = (parent node if any, relationship, node key, text to show with node)

'Basic code for adding node to TreeView control 'Node Text = Text you see in the tree view The index is a number based on position in tree hierachy. 'Node Key = unique identifier for each node, AND must be text (so numbers must be used as '1 and so on). Style = 7 'TreelinesPlusMinusPictureText VBA code for working with a Treeview control Dim nParent As Node, nChild As Node One that fills out child nodes when you expand a parent node, and another that fills out all the node on the form's open even ( could be slow if you have a lot of nodes).

Two versions of the 'Music' data example.

Nodes are populated from stored queries each query contains a nodeID and nodeText field that is used to set the.

Also, includes a 'Music' data form that fills out nodes different levels from different data sources for each level ( uses data from this article, Artists->Albums->Songs).

Child nodes are only completely added when you expand a parent node.

Only the first level nodes are filled out when you open the form ( as well as the first child, if any, so that there is a + for that node).

Nodes are populated from a DAO recordset using a SQL string statement.

Example 'Groups' TreeView populating using the table described above.

Here's the highlights of the Microsoft Access sample file It's easier to step through it yourself then for me to try to explain it all. I will only be post parts of the code and explaining them. Here's the data I created in the sample database.ĭownload the sample file to follow along. In the article I will be referring to a form in an Access database and populating data from a single table ( the sample file also shows populating from multiple sources), but the method of adding nodes is the same what differs is how you get the data used to populate the TreeView control. I've created sample files for both a form in Microsoft Access and worksheet in Microsoft Excel. You could have an Excel table that looks like this, too. This is an example of a a self-join table in a database, i.e. The following table shows how I would store a single parent node that has to child nodes. All nodes can have children ( subfolders). The top folder is the parent and the folder within it are the children. You've probably used a TreeView to view a hard drive directory structure before, you click on a folder and expand it to show the folders within that that folder.

Visual basic for excel not showing