[AccessD] Select a node in a treeview

Jack and Pat drawbridgej at sympatico.ca
Tue Oct 6 18:42:36 CDT 2009


Max,

I haven't looked at Treeview since you and I were in contact back in the
spring. I did find this reference material via google. Hope it might be
useful.

http://www.databasejournal.com/features/msaccess/article.php/3734331/Access-
TreeView-ListView-Basics.htm

Jack


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Tuesday, October 06, 2009 5:32 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Select a node in a treeview

Is there any intelisense with treeview? 

Anybody?

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: 06 October 2009 17:03
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Select a node in a treeview

This would be something you need to do based on the Key values.

So let's say you have a simple treeview based on one table that has an 'ID'
field.

When you create the node, set the key to "ID:" & rs.fields("IDField").value

Then to retrieve the node:

tvwData.Nodes("ID:" & rs.fields("IDField").value)

for more complex treeviews, with multiple sources, it's just a matter of
extending the process.  For example, I have a 'request' treeview, which will
show user requests (tblRequests), along with Interim Reports, Final Reports,
'Punts', Purchase Requests, etc.  All from different tables.  Each of those
other tables have a unique key, BUT, the keys COULD be the same from a
request and an interim report(or any other sub 'object').  So, my
requestNodes would be:

"ID:1", "ID:2006", etc.

My Interim Report nodes would be:

"ID:1:INTRM:12"  (so this key tells me it's request 1, with Interim 12).

This way, when I ask for "ID:1", I get the request node.  If I ask for
"ID:1:INTRM:12" I get the interim node, and I never have a clash of IDs.  I
can also tell what the node represents from the key this way too.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dale Kalsow
Sent: Monday, October 05, 2009 12:08 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Select a node in a treeview




Good Afternoon,
 
Can anyone tell me how to select a node in a treeview?  I want to select it
based on a the value of the current record (not that it probably matters) :)
 
thanks!
 
Dale


      
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the
person or entity 
to which it is addressed and may contain II-VI Proprietary and/or II-VI
Business 
Sensitive material. If you are not the intended recipient, please contact
the sender 
immediately and destroy the material in its entirety, whether electronic or
hard copy. 
You are notified that any review, retransmission, copying, disclosure,
dissemination, 
or other use of, or taking of any action in reliance upon this information
by persons 
or entities other than the intended recipient is prohibited.


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list