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 36 37
| Private Sub Command1_Click()
Dim rec As New ADODB.Recordset
'execution de la procédure sub
'execrec
Dim VarCmp, VarCpt, VarStatut As String
Dim i, j As Integer
'Selection du Statut (Rapprochées, Non Rapprochées, Archivées)
VarStatut = VarStatut & "'" & (Me.cbxstatut) & "'" & ","
'initialisation de i,j
i = 0
j = 0
For i = 0 To lstcmp.ListCount - 1
Print Form1.lstcmp.TabIndex
If lstcmp.Selected(i) = True Then
VarCmp = "'" & RTrim(Me.lstcmp.Text) & "',"
End If
Next i
VarCmp = Left(VarCmp, Len(VarCmp) - 1)
For j = 0 To lstacc.ListCount - 1
If lstacc.Selected(j) = True Then
VarCpt = "'" & (Me.lstacc.Text) & "',"
End If
Next j
VarCpt = Left(VarCpt, Len(VarCpt) - 1)
Set rec = xu2.VUE_ETAT(Me.ctldate.Value, (VarCmp), (VarCpt), (VarStatut)) |
Partager