'Choix des element de la table a utiliser
MonRs.Open "SELECT EmployeeID,StartPauseTime,EndPauseTime FROM ServicePause Where EmployeeID=1
", cnn1, adOpenKeyset, adLockOptimistic
'affichage des elements selectionnés
Set MSHFlexGrid1.DataSource = MonRs
'Calcule du temps de pause et du nomber d'iteration
Dim nest, qw, qwe As Date
Dim qq As Integer
Dim i As Integer
'Choix des element de la table a utiliser
MonRs.Open "SELECT EmployeeID,StartPauseTime,EndPauseTime FROM ServicePause Where EmployeeID=1", cnn1, adOpenKeyset, adLockOptimistic
'Calcule du temps de pause et du nomber d'iteration
Dim nest As As Date
Dim qw As Date
Dim qwe As Date
Dim qq As Integer
Dim i As Integer
qq = MonRs.RecordCount
i = 0
Do While MonRs.EOF = False
i = i + 1
qw = MonRs.Fields("StartPauseTime").Value
qwe = MonRs.Fields("EndPauseTime").Value
nest = DateDiff ("s", [qw], [qwe])
With MSHFlexGrid1
.AddItem (MonRs.Fields!EmployeeID)
.Col = i
.Text = nest
End With
MonRs.MoveNext
Loop
'Affichage du temps de pause et du nomber d'iteration
Text1.Text = nest
Text2.Text = qq
Set cnn1 = Nothing
Set MonRs = Nothing