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
| Option Compare Database
Dim db As database
Dim rArchive As Recordset
Dim f As Field
Option Explicit
Private Sub Form_current() ' Vérifier la condition ci dessous tout le temps
Dim mess As String
mess = "Voulez-vous vraiment supprimer l'enregistrement courant?"
If vbYes = MsgBox(mess, vbYesNo + vbDefaultButton2 + vbQuestion) Then
Call ArchiverRecord
Else
Cancel = CInt(True)
End If
End Sub
Private Sub Efface_Click()
On Error GoTo Err_Efface_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
Exit_Efface_Click:
Exit Sub
Err_Efface_Click:
MsgBox Err.Description
Resume Exit_Efface_Click
End Sub
Private Sub ArchiverRecord()
Dim db As Database: Set db = CurrentDb
Dim rArchive As Recordset: Set rArchive = db.OpenRecordset("Archive")
Dim f As Field
rArchive.AddNew
For Each f In prmForm.Recordset.Fields()
rArchive.Fields(f.Name) = f
Next f
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
rArchive.Update
rArchive.Close: Set rArchive = Nothing
db.Close: Set db = Nothing
End Sub
Private Sub ret_menu_Click()
On Error GoTo Err_ret_menu_Click
DoCmd.Close
Exit_ret_menu_Click:
Exit Sub
Err_ret_menu_Click:
MsgBox Err.Description
Resume Exit_ret_menu_Click
End Sub |
Partager