1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| If (Me.CodeG <> "") And Not IsNull(Me.CodeG) Then
j = DateDiff("d", DateSerial(Forms!F_Planning!An, Forms!F_Planning!Mois, 1), CDate(Me.DateJ)) + 1
Me.Requery
MajPlanning
' Déplacement sur la case du planning correspondant au matricule et au jour choisis.
Forms!F_Planning!SF_Planning.Form.RecordsetClone.FindFirst "[Matricule]=" & Nz(Me.Matricule, 0)
Forms!F_Planning!SF_Planning.Form.Bookmark = Forms!F_Planning!SF_Planning.Form.RecordsetClone.Bookmark
Forms!F_Planning!SF_Planning.Form("Jour" & CStr(j)).SetFocus
DoCmd.Close acForm, "F_Saisie"
Else
MsgBox ("Saisir une garde !")
End If |
Partager