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
| Dim varTableau As Variant
Dim intLignes As Integer
Dim sql As String
Dim rsTech As Recordset
Dim dbTech As Database
sql = "SELECT Tech.N°_Tech, Tech.Nom, Tech.Prenom "
sql = sql & "FROM Tech WHERE N°_Tech = " & ÉtiquetteTechCA2.Caption & " "
Set dbTech = CurrentDb()
Set rsTech = dbTech.OpenRecordset(sql)
If Not rsTech.EOF Then
varTableau = rsTech.GetRows(1000)
intLignes = UBound(varTableau, 2)
ListeTechCA2.RowSource = ""
ListeTechCA2.AddItem Item:="N°;Nom;Prénom", Index:=0
For i = 0 To intLignes
ListeTechCA2.AddItem Item:=varTableau(0, i) & ";" & varTableau(1, i) & ";" & varTableau(2, i)
Next i
Else
MsgBox "Problème pour lister tous les techniciens", vbExclamation, "Connexion impossible"
End If
rsTech.Close
dbTech.Close
Set rsTech = Nothing
Set dbTech = Nothing |
Partager