Topics Search

TreeView Control

TreeView Control
Views: 166
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:

More topics

 

Access 2003 ActiveX Treeview Control

Preview
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?

Preview
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?

Preview
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)

Preview
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

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

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

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

Add records to treeview and listview

Preview
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 2000 How To's: Adding a Tree View Control and Filter

Preview
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

Preview
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
 

How to useSplitContainer or Splitter in forms

Preview
I have created MS ACECSS (2007) forms that are using "TreeView" control on the left and a connected form on the right. But there is a problem. the border between them is fixed. I want to implement a "SplitContainer" Control or "Splitter" that will have a Treeview on the left side and the associated form on the right side and i can move the border between them.

I have seen many examples on the web for VB but could not understand how to implement it with MS ACECSS VBA. I was looking for the relevant OCX in windows.form for example. I was looking for the an ObjectX "Splitter" control in MS ACCES VBA, but none found. Here are some references that i came across...