Option Explicit Dim Rst As Recordset Dim mNode As Node Dim mNode1 As Node Private Sub Form_Load() Set Db = DBEngine.OpenDatabase("z:\bd1.mdb") Call RemplirTV End Sub Private Sub RemplirTV() Dim t As Integer, n As Integer Set mNode = TV.Nodes.Add() mNode.Text = "PC" Set mNode1 = TV.Nodes.Add() Set Rst = Db.OpenRecordset("select group from pcseb order by group", dbOpenDynaset) While Not Rst.EOF For t = 1 To n mNode1(t).Text = Rst!Group Rst.MoveNext Next t Rst.Close End Sub
Private Sub RemplirTV() Dim i As Integer Set mNode = TV.Nodes.Add() mNode.Text = "PC" Set mNode1 = TV.Nodes.Add() Set Rst = Db.OpenRecordset("select group from pcseb group by group order by group", dbOpenSnapshot) While Not Rst.EOF mNode1.Text = Rst!Group mNode1 = TV.Nodes.Add(1) Rst.MoveNext Wend Rst.Close End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub RemplirTV(C1 As TreeView) Dim Rst As Recordset, Rst2 As Recordset, NodeX As Node Dim IndexGroup As Long, NomNoeud As String C1.Nodes.Clear Set Rst = Db.OpenRecordset("Select * from pcseb order by group asc", dbOpenSnapshot) Set NodeX = C1.Nodes.Add(, , , "PC") C1.Nodes.Item(NodeX.Index).Bold = True While Not Rst.EOF Set Rst2 Db.OpenRecordset("select * from pcseb where group group") If Not Rst2!Group = NodeX.Text Then Set NodeX = C1.Nodes.Add(1, tvwChild, , Rst!Group) C1.Nodes.Item(NodeX.Index).Tag = 1 & "|" & Rst!Numéro IndexGroup = NodeX.Index Rst.MoveNext End If Wend Rst.Close End Sub
Private Sub RemplirTV(C1 As TreeView) Dim Rst As Recordset, Rst2 As Recordset, NodeX As Node Dim IndexGroup As Long, NomNoeud As String C1.Nodes.Clear Set Rst = Db.OpenRecordset("Select * from pcseb order by group asc", dbOpenSnapshot) Set NodeX = C1.Nodes.Add(, , , "PC") C1.Nodes.Item(NodeX.Index).Bold = True While Not Rst.EOF Set NodeX = C1.Nodes.Add(1, tvwChild, , Rst!Group) C1.Nodes.Item(NodeX.Index).Tag = 1 & "|" & Rst!Numéro IndexGroup = NodeX.Index Rst.MoveNext End If Wend Rst.Close End Sub