Dim ccadre_ent As New ADODB.Connection Dim rent11 As New ADODB.Recordset Dim rent12 As New ADODB.Recordset ccadre_ent.Provider = "Microsoft.Jet.OLEDB.4.0" ccadre_ent.ConnectionString = "C:\cadre_ent.mdb" Set rent11 = New ADODB.Recordset Set rent12 = New ADODB.Recordset If rent11.RecordCount <> 0 And rent12.RecordCount <> 0 Then Do While Not rent11.EOF Do While Not rent12.EOF List1.AddItem rent11("num") & " " & IIf(IsNull(rent12("essai")), "", rent12("essai")) rent12.MoveNext Loop rent12.MoveFirst rent11.MoveNext Loop End If Set rent12 = Nothing Set rent11 = Nothing Set ccadre_ent = Nothing
If rent11.RecordCount <> 0 And rent12.RecordCount <> 0 Then Do While Not rent11.EOF Do While Not rent12.EOF List1.AddItem rent11("num") & " " & IIf(IsNull(rent12("essai")), "", rent12("essai")) rent12.MoveNext Loop rent12.MoveFirst rent11.MoveNext Loop End If Set rent12 = Nothing Set rent11 = Nothing Set ccadre_ent = Nothing
homme cinq homme deux homme huit homme un homme quatre homme sept homme six homme trois
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question