[AccessD] Arthur's Treeview

ACTEBS actebs at actebs.com.au
Thu Sep 30 09:58:58 CDT 2004


Alun,

You're a superstar...

Thanx
Vlad

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Garraway,
Alun
Sent: Friday, 1 October 2004 12:03 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Arthur's Treeview


Hi Vlad,

I use the Node.Key to store that info.

here's some test code

hth
alun

Private Sub tvwSpot_ON_NodeClick(ByVal Node As Object)

    Dim strLeval As String
    
    With Node
        strLeval = Left(.Key, 2)

        Select Case strLeval
        
        Case "WG"
            MsgBox "this is leval 1 " & .Key
            
        Case "AR"
            MsgBox "this is leval 2 " & Right(.Key, 6)
        Case Else
            MsgBox "nothing! " & .Key
        End Select
    End With
End Sub

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of ACTEBS
Sent: Thursday, September 30, 2004 3:07 PM
To: access group
Subject: [AccessD] Arthur's Treeview


Hi everyone,
 
I am mucking around with Arthur's Tree view control using DAO. What I
can't figure out is how you get the ID of the item selected within the
treeview itself so I can use it to filter a recordset. For example:
 
Level 1 = ProductCategory eg Dairy
Level 2 = Product eg Goats Milk
 
I want to be able to get the ProductCategoryID as I am only able to get
the ProductCategoryText out at the moment in Level 1. This also applies
to the Level 2 where I'd prefer to obtain the ProductID rather than the
ProductDescription. Obviously I don't want the user to see these
values...
 
Any help much appreciated...
 
Vlad
 
 
-- 
_______________________________________________
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