1 2 3 4 5 6 7 8 9 10 11 12 13 14
| Set rsSource2 = dbSource.OpenRecordset("SELECT int([Date_enr]) FROM Donnees2 WHERE int([202]) = " & Str(Me.BLRecherche.Value), dbOpenDynaset)
For i = 0 To rsSource2.Fields.Count - 1
If (ValidDesigne2(i) = True) Or (i = j) Then
Sheets(1).Cells(Ligne, Colonne) = rsSource2.Fields(i)
Select Case rsSource2.Fields(i).Type
Case 4, 7
Sheets(1).Cells(Ligne, Colonne).NumberFormat = "#00.00"
Case 8
Sheets(1).Cells(Ligne, Colonne).NumberFormat = "dd/mm/yy h:mm:ss"
End Select
Colonne = Colonne + 1
End If
Next i
rsSource2.MoveNext |
Partager