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 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
| Option Compare Database
Private Sub Commande82_Click()
On Error GoTo Err_Commande82_Click
DoCmd.GoToRecord , , acNewRec
Exit_Commande82_Click:
Exit Sub
Err_Commande82_Click:
MsgBox Err.Description
Resume Exit_Commande82_Click
End Sub
Private Sub Commande83_Click()
On Error GoTo Err_Commande83_Click
DoCmd.GoToRecord , , acNewRec
Exit_Commande83_Click:
Exit Sub
Err_Commande83_Click:
MsgBox Err.Description
Resume Exit_Commande83_Click
End Sub
Private Sub Commande84_Click()
On Error GoTo Err_Commande84_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
Exit_Commande84_Click:
Exit Sub
Err_Commande84_Click:
MsgBox Err.Description
Resume Exit_Commande84_Click
End Sub
Private Sub Commande85_Click()
On Error GoTo Err_Commande85_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_Commande85_Click:
Exit Sub
Err_Commande85_Click:
MsgBox Err.Description
Resume Exit_Commande85_Click
End Sub
Private DateTrempage As Date
Private Sub DateTremp_AfterUpdate()
DateTrempage = DateTremp
End Sub
Private Sub Form_Current()
If Me.NewRecord And DateTrempage <> 0 Then DateTremp = DateTrempage
End Sub
Private Sub DateTremp_BeforeUpdate(Cancel As Integer)
End Sub |
Partager