? maVariablepour qu'elle s'inscrive dans la fenêtre.
Option Explicit Dim Rs As New ADODB.Recordset Dim Rs3 As New ADODB.Recordset Public cnn As New ADODB.connection Private Sub Form_Load() Rs3.Open "select * from marques ", cnn, adOpenKeyset, adLockOptimistic If Rs3.RecordCount > 0 Then i = 1 Rs3.AbsolutePosition = 1 MSFlexGrid1.Rows = 1 Do While Not Rs3.EOF MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1 c = Rs3.Fields("nom_marque") i = i + 1 Rs3.MoveNext Loop End If Rs.Open "select * from serveur", cnn, adOpenKeyset, adLockOptimistic If Rs.RecordCount > 0 Then i = 1 Rs.AbsolutePosition = 1 MSFlexGrid1.Rows = 1 Do While Not Rs.EOF MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1 MSFlexGrid1.TextMatrix(i, 1) = Rs.Fields(0) MSFlexGrid1.TextMatrix(i, 2) = Rs.Fields(1) MSFlexGrid1.TextMatrix(i, 3) = c MSFlexGrid1.TextMatrix(i, 4) = Rs.Fields(3) i = i + 1 Rs.MoveNext Loop End If Rs.Close Rs3.close end sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question