TreeView: How to select an item via VBA?

[PeteCresswell]

I've just added a new record to the backend DB and reloaded the
TreeView that shows the user all records in the DB.

Now I want to programatically position the TreeView at the newly-added
record and have it that branch of the tree selected.

Anybody know how to do this?

[PeteCresswell]

Anybody know how to do this?

I tried what seemed like the obvious:

treDeal.Nodes("Whatever").Select

but it always throws a 35601 "Element not found"

[Rich P]

Hi Pete,

I hope this can get you started. The tricky part is that none of the
methods I show here show up in the dropdown for the treeview control. I
got a sample of treeview code from the internet somewhere. I
simplified it a bit to illustrate the relationship of the nodes.

This code assumes you have a treeview control on your form called
Treeview0

Private Sub Form_Load()

Me.TreeView0.Nodes.Clear

Me.TreeView0.LineStyle = tvwRootLines
Me.TreeView0.Indentation = 100

Me.TreeView0.Nodes.Add Key:="Main", Text:="myMain"
Me.TreeView0.Nodes.Add Relative:="Main", _
relationship:=tvwChild, Key:="Test", Text:="Test"

Me.TreeView0.Nodes.Add Relative:="Test", _
relationship:=tvwChild, Key:="Test1", Text:="myTest1"

Me.TreeView0.Nodes.Add Relative:="Test1", _
relationship:=tvwChild, Key:="Test1a", Text:="myTest1a"

Me.TreeView0.Nodes.Add Relative:="Test1", _
relationship:=tvwChild, Key:="Test1b", Text:="myTest1b"

Me.TreeView0.Nodes.Add Relative:="Test", _
relationship:=tvwChild, Key:="Test2", Text:="myTest2"

Me.TreeView0.Nodes.Add Relative:="Test", _
relationship:=tvwChild, Key:="Test3", Text:="myTest3"

End Sub
Note: tvwChild and tvwRootLines are constants that are part of the
Treeview control. There are more constants with specific names that are
part of the Treeview control. You can look these up on the internet.
There is a constant for adding images to the list

Me.TreeView0.Style = tvwTreelinesPlusMinusPictureText

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[Mike Gramelspacher]

In article <11*********************@75g2000cwc.googlegroups.c om>,
Go**********@FatBelly.com says...

I've just added a new record to the backend DB and reloaded the
TreeView that shows the user all records in the DB.

Now I want to programatically position the TreeView at the newly-added
record and have it that branch of the tree selected.

Anybody know how to do this?

I posted the code I use here:
http://www.psci.net/gramelsp/temp/frmFamilies_code.txt

See Form 4 here. This is an image of the treeview form.
http://www.psci.net/gramelsp/temp/ChurchTemplate.html

All it does it basically use someone elses's code as not in the code
remarks.

[PeteCresswell]

Mike Gramelspacher wrote:

http://www.psci.net/gramelsp/temp/frmFamilies_code.txt

Thanks Mike. MyTreview_FindNode(strKey) looks like what I'm trying to
do.

I was trying to do it based on Node.Text. Now it's obvious that I
need to concoct the key and use that.

[PeteCresswell]

PeteCresswell wrote:

I was trying to do it based on Node.Text. Now it's obvious that I
need to concoct the key and use that.

Which begs another question: Is there any place for me to squirrel
away data that the user does not see besides .Key?

Right now, I'm embedding a bunch of stuff in .Key that will be
difficult or impossible to back into when I need to do a search.

If I could put it somewhere else and simplify the key, my problem would
be solved.

[PeteCresswell]

PeteCresswell wrote:

Is there any place for me to squirrel
away data that the user does not see besides .Key?

Oops!... Frivolous question... my figurative mouth got out of control
before I had the sense to browse the object.

..Tag is my vehicle....