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
| Private Sub execute_Click()
Dim prmUserId As Long, prmDateDebut As Date, prmDateFin As Date, prmYUANYING As String
Dim db As DAO.Database: Set db = CurrentDb
Dim r As DAO.Recordset: Set r = db.OpenRecordset("USER_SPEDAY", dbOpenDynaset)
Const MyTime = #11:59:00 PM#
If Not (IsNull(Me.prUserId) Or IsNull(Me.prDateDebut) Or IsNull(Me.prDateFin) Or IsNull(Me.prYUANYING)) Then
prmUserId = Forms("Formulaire1").Controls("prUserId").Value
prmDateDebut = Forms("Formulaire1").Controls("prDateDebut").Value
prmDateFin = Forms("Formulaire1").Controls("prDateFin").Value
prmYUANYING = Forms("Formulaire1").Controls("prYUANYING").Value
Dim iDate As Date: For iDate = prmDateDebut To prmDateFin
r.AddNew
r![UserId] = prmUserId
r![StartSpecDay] = iDate
r![ENDSPECDAY] = iDate + MyTime
r![DateId] = 2
r![YUANYING] = prmYUANYING
r![Date] = Now()
r.Update
Next iDate
Else
MsgBox " Complétez toutes les zones SVP ."
End If
r.Close: Set r = Nothing
db.Close: Set db = Nothing
End Sub |
Partager