1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| 'Fonction pour ajouter les valeurs dans la table T_temp
Public Sub AjoutTrancheH(parDebut As Date, parFin As Date, _
parCentre As String, parLib As String, _
parPers As Integer, parNumer As Integer)
Dim rstTemp As DAO.Recordset
Dim valdate As Date
valdate = parDebut
Set rstTemp = CurrentDb.OpenRecordset("T_temp", dbOpenDynaset)
With rstTemp
While valdate <= parFin
.AddNew
![NumEnr] = parNumer
![IdPersonne] = parPers
![Centre] = parCentre
![PLANNING_ETAT_LIBELLE_COURT] = parLib
![DateEnr] = DateValue(valdate)
![TrancheHEnr] = IIf(Hour(valdate) = 24, 0, Hour(valdate))
.Update
valdate = DateAdd("h", 1, valdate)
Wend
End With
rstTemp.Close
Set rstTemp = Nothing
End Sub |
Partager