Dim I As String SQL = "SELECT `Pseudo` FROM `Utilisateurs` " SQL = SQL + "WHERE `Articles`=1 AND `Facturation`=1 AND `Banque`=1 AND `Comptabilite`=1" DataReq.DatabaseName = App.Path & "\DataBase.mdb" DataReq.RecordSource = SQL DataReq.Refresh If Not (DataReq.Recordset.BOF And DataReq.Recordset.EOF) Then DataReq.Recordset.MoveLast DataReq.Recordset.MoveFirst Do While Not DataReq.Recordset.EOF I = I + DataReq.Recordset!L_AdminName DataReq.Recordset.MoveNext Loop DataReq.Refresh End If
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionWith monRecordSet If .RecordCount > 0 Then .MoveFirst Do While Not .EOF Debug.Print .Fields("Toto").Value .MoveNext DoEvents Loop End If End With