Topics Search

TreeView Control

TreeView Control
Views: 181
I was wondering if it is possible to open a treeview control expanded to a certain child node.

I use a form(Form1) with a treeview control to make a selection which populates a subform (On the same form as the Treeview control) which is bound to a record from an access table. Some fields of this subform are then used in another Form(Form2) with Subform to make a calculation, This works.

Now I would like to sort of work this logic backwards so that when a textbox on a Form(Form2) receives focus, the form(Form1) with the treeview control opens,with the treeview control expanded to the proper child node
Sponsored Links:

Similar posts...

 

Access 2003 ActiveX Treeview Control

Access 2003 ActiveX Treeview Control Icon
I have, with great difficulty and much seeking of examples on the internet(successfully) set up an TreeView control on my form - the above withstanding, I still find it incredible difficult to get any comprehensive information about it (pertaining to VBA and Access) - I need to do things like set node colour backgrounds, select parent nodes, refresh the treeview after deleting a record but opening to the parent node and so on and on.

Does anyone have any idea where I may get a comprehensive paper explaining the TreeView control with all it's properties, events and so on?

P.S. Don't know why Microsoft make it so hard to use and find comprehensive information on this control while so many other controls are easy to use and well documented within Access.
 

Third Party TreeView Control?

Third Party TreeView Control? Icon
I'm totally stuck and hoping someone can point me in the right direction here, be it with the TreeView control within Access, or to a third-party control (i'm kinda assuming it's gonna be the latter option).

I have data in a table that looks like this:

FundingYear ReferralYear TotalDollars TotalUnits
2008 Total 1000 50
2007 Total 1200 80

What I'm really hoping to get here is a treeview, where the top branch shows the "Total" line.so as an example you'd see 2008, Total, 1000, 50.

Then, when expanding the branch, you'd get the individual lines that make up the total.

I can't for the life of me see how to do with with the common treeview control, but maybe I'm missing something
 

Third-Party Treeview Control?

Third-Party Treeview Control? Icon
I'm totally stuck and hoping someone can point me in the right direction here, be it with the TreeView control within Access, or to a third-party control (i'm kinda assuming it's gonna be the latter option).

I have data in a table that looks like this:

FundingYear ReferralYear TotalDollars TotalUnits
2008 Total 1000 50
2007 Total 1200 80

What I'm really hoping to get here is a treeview, where the top branch shows the "Total" line.so as an example you'd see 2008, Total, 1000, 50.

Then, when expanding the branch, you'd get the individual lines that make up the total.

I can't for the life of me see how to do with with the common treeview control, but maybe I'm missing something
 

Creating Treeview in Access (2010)

Creating Treeview in Access (2010) Icon
Is it possible to create a true treeview in Access 2010 like it is in VB.Net ?

I have a table out of HR which gives each staffID and their Supervisors ID. I want to create a treeview picklist where the Supervisors and see subordinates and select documents from that subordinate. I could do with multiple updating ListBoxes but would prefer something like a TreeView Structure
 

Treeview control - getting selected node value from recordset

Treeview control - getting selected node value from recordset Icon
I have downloaded this snippet from MSDN library. I have a table with 3 fields and a query for the table. The fields are

'qryTVNode' (name of query

TVNID (Autonumber PK ID)
TVNName (Treeview Node Name)
TVNparID (field holds the parent ID it is related to)

I have the treeview populated and everything is working great. Now on to the next step. I need to get the value of the TNNparID of the selected node. I have a textbox on this formtxtSelNode that I would like this value placed after selection.

strPointerField is the field in the recordset that would hold the value I need.
 

Add records to treeview and listview

Add records to treeview and listview Icon
I have implemented a treeview and listview in a form which displays records just fine.
I have separate forms for adding /editing records for the respective tables.
If it is possible to achieve the add/edit functionality with treeview and listview, I can dispense with the extra forms.
If not possible directly, would it be possible to code the node click event to open the respective editable form and refresh the treeview upon update
 

Access 2010 Treeview control not working. After Aug 18th update

Access 2010 Treeview control not working. After Aug 18th update Icon
There was a Windows and Office 2010 update dated August 18th. Microsoft Access 2010 TreeView control does not work after this update is installed. The events are not firing (right Click and NodeClick).

I noticed this issue when I created a PC to test Office 2013 suggesting updates required for 2013 are cause the problem.
 

Access 2000 How To's: Adding a Tree View Control and Filter

Access 2000 How To's: Adding a Tree View Control and Filter Icon
This Access 2000 How To's article explains how to load data into a treeview control. Nodes in a treeview have a parent key and a child key. In this example, the first level of nodes contains process ids and titles. In the second level, Activities represent dependant child nodes. One or more activies are associated as children to the a process.
 

Responding To Clicks On Treeview Nodes

Responding To Clicks On Treeview Nodes Icon
I've managed to correctly populate a treeview control on a Access form. Now I need to tie VBA code (in modules) to individual nodes. In other words, when a specific node is clicked, a specific sub needs to be executed.

However, I see no "On Click" event.I see an "On Updated" "On Enter" "On Exit" "On Got Focus" "On Lost Focus" event, but nothing that corresponds to a mouse click.

How to I get SubA to execute when treeview.node("SubA") is clicked
 

4 tier treeview

4 tier treeview Icon
I was hoping that somebody might be in a position to help me for a change

Trying in vein to work out a treeview but there are so many different ways to do it.

I need a 4 tier treeview. I wondered if the best was to have 4 tables as there can be many items per treeview item or just use 1 table? Example

4 main items in the tree
Each item has 6 sub items
Each sub item has 10 sub items
Each sub sub items have 2 items

Or in other words (a typical full tree)

1. Workshop
.|______2. Material
.|.|_______3. Wood
.|.|.|______4. Tulip
.|.|.|______4. Pine
.|.|_______3. laminate
.|.|.|______4. polyrey
.|.|.|______4. print
.|______2. Labour
.|_______3. office
.|______4. managment

Another reason was I wanted the ability to add treeview items by code.

Some examples I've seen have only 1 table with tier numbers which all looks a bit confusing.

Is anyone feeling generous enough to help me today?

I'd be very grateful if there was