Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionOption Explicit Private Sub Form_Load() Dim db As New clsdb db.DBConnect "c:\tmp2003.mdb", , Jet4x db.RSExecute "SELECT * FROM tableformation ORDER BY numformation;" MsgBox "nombre d'enregistrements = " & db.RS.Fields.Count db.RSExecute "SELECT DISTINCT numformation FROM tableformation ORDER BY numformation;" MsgBox "nombre d'enregistrements = " & db.RS.Fields.Count db.DBClose Set db = Nothing Unload Me End Sub
Dim rsformation As New Recordset
rsformation.Open "select numformation from Tableformation ", cn, 2, 3
Dim rsmission As New Recordset
rsmission.Open "select * from (select distinct nummission from Tabletempmission)", cn, 2, 3
Dim rsmission As New Recordset
rsmission.Open "select * from tabletempmission where nummission = (select distinct nummission from Tabletempmission)", cn, 2, 3
Dim rsmission As New Recordset
rsmission.Open "select * from tabletempmission where nummission = (select distinct nummission from Tabletempmission)", cn, 2, 3
Dim rs2 As New Recordset
Dim rs3 As New Recordset
Dim rs4 As New Recordset
Dim rs5 As New Recordset
i = 1
While (Not rsmission.EOF)
If Not IsNull(rsmission) Then
rs3.Open "select tableimputation.imputation from tableimputation, tabletempmission where tabletempmission.numimputation tableimputation.numimputation and idmission " & rsmission(0) & "", cn, adOpenDynamic, adLockOptimistic
rs4.Open "select tablechauffeur.nomprenomchauffeur from tablechauffeur, tabletempmission where tabletempmission.numchauffeur tablechauffeur.numchauffeur and idmission " & rsmission(0) & "", cn, adOpenDynamic, adLockOptimistic
rs5.Open "select tablevehicule.vehicule from tablevehicule, tabletempmission where tabletempmission.numvehicule tablevehicule.numvehicule and idmission " & rsmission(0) & "", cn, adOpenDynamic, adLockOptimistic
If IsNull(rsmission(1)) Then
msfmission.TextMatrix(i, 0) = ""
Else
msfmission.TextMatrix(i, 0) = rsmission(1)
End If
If IsNull(rsmission(0)) Then
msfmission.TextMatrix(i, 1) = ""
Else
msfmission.TextMatrix(i, 1) = rsmission(0)
End If
..................................................................
.................................................................
If IsNull(rs2(0)) Then
msfmission.TextMatrix(i, 14) = ""
Else
msfmission.TextMatrix(i, 14) = rs2(0)
End If
End If
i = i + 1
rsmission.MoveNext
Wend
msfmission.Refresh
rsmission.Close
Set rsmission = Nothing
Set rs2 = Nothing
Set rs3 = Nothing
Set rs4 = Nothing
Set rs5 = Nothing
msfmission_Click