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 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| Public Function ResHebdo(Js, Dsd, Dsf As Variant) As Variant
On Error Resume Next
Dim Rsem, Sx As Variant
Rsem = 0
strg = Js & "/" & mm & "/" & aa
Sx = CDate(strg)
DspN = Int(Dsp)
DsfN = Int(Dsf)
If (Sx >= DspN) And (Sx <= DsfN) Then Rsem = 1
ResHebdo = Rsem
End Function
Function Remplirhebdo(ChoixDate As Variant)
Dim ReqData As New Recordset, str As String
ChoixDate = [Formulaires]![Choix_Date]![Date1]
str = " SELECT Hebdo.Numero_Tvx, Hebdo.Postes, Hebdo.NOM_EXPL, Hebdo.DATE_HEURE_DEBUT, Hebdo.DATE_HEURE_FIN, Hebdo.JLun, Hebdo.JMar, Hebdo.JMer, Hebdo.JJeu, Hebdo.JVen, Hebdo.JSam, Hebdo.JDim, FROM Hebdo"
ReqData.Open str, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
Js = ChoixDate
Do Until ReqData.EOF
ReqData!JLun = ResHebdo(Js, ReqData!DATE_HEURE_DEBUT, ReqData!DATE_HEURE_FIN)
ReqData!JMar = ResHebdo(Js + 1, ReqData!DATE_HEURE_DEBUT, ReqData!DATE_HEURE_FIN)
ReqData!JMer = ResHebdo(Js + 2, ReqData!DATE_HEURE_DEBUT, ReqData!DATE_HEURE_FIN)
ReqData!JJeu = ResHebdo(Js + 3, ReqData!DATE_HEURE_DEBUT, ReqData!DATE_HEURE_FIN)
ReqData!JVen = ResHebdo(Js + 4, ReqData!DATE_HEURE_DEBUT, ReqData!DATE_HEURE_FIN)
ReqData!JSam = ResHebdo(Js + 5, ReqData!DATE_HEURE_DEBUT, ReqData!DATE_HEURE_FIN)
ReqData!JDim = ResHebdo(Js + 6, ReqData!DATE_HEURE_DEBUT, ReqData!DATE_HEURE_FIN)
ReqData.MoveNext
Beep
Loop
End Function |
Partager