1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| Private Sub Commande0_Click()
Dim WithEvents rsCli As ADODB.Recordset
Dim WithEvents rsEmp As ADODB.Recordset
Dim WithEvents rsCde As ADODB.Recordset
Dim sup As String
'Private Sub cmdUpdate_Click()
'déclaration des variables
Dim x As Node
'Réaffectation des recordsets pour mise à jour
sup = MsgBox("des recordsets", vbCritical + vbYesNo + 256, "Réaffectation")
If rsCli.State = adStateClosed Then rsCli.Open "Clients", CurrentProject.Connection, adOpenStatic
If rsEmp.State = adStateClosed Then rsEmp.Open "Employés", CurrentProject.Connection, adOpenStatic
rsCli.Requery: rsCli.MoveFirst
rsEmp.Requery: rsEmp.MoveFirst
'Définition du treeview
ocxTree.Nodes.Clear
'--Clients
Set x = ocxTree.Nodes.Add(, , "c", "Clients", 1)
x.ExpandedImage = 2
Do Until rsCli.EOF
Set x = ocxTree.Nodes.Add("c", tvwChild, "C-" & rsCli(0), rsCli(1) & " (" & rsCli(2) & ")", 1)
rsCli.MoveNext
Loop
'--Employés
Set x = ocxTree.Nodes.Add(, , "e", "Employés", 1)
x.ExpandedImage = 2
Do Until rsEmp.EOF
Set x = ocxTree.Nodes.Add("e", tvwChild, "E-" & rsEmp(0), rsEmp(1) & " " & rsEmp(2), 1)
rsEmp.MoveNext
Loop
End Sub |
Partager