هذا إجراء للزر في حدث عند النقر
Private Sub cmdDelet_Click()
Dim Records As Long
Dim Msg As String
Dim ctl As Control
Dim TableName As String
On Error Resume Next
TableName = "tblTable1"
Set ctl = Me.n
If Trim(Nz(ctl, "")) = "" Then
MsgBox "الحقل فارغ .. يجب أن يحتوي على قيمة ما", , "عفوًا"
ctl.SetFocus
GoTo ExitSub
End If
Records = DCount("*", TableName, "n=" & ctl)
If Records = 0 Then
MsgBox "لا يوجد سجلات بنفس القيمة لحذفها", , "عفوًا"
GoTo ExitSub
End If
Msg = "سوف يتم حذف " & Records & " سجلات نهائيا الآن"
If vbOK = MsgBox(Msg, vbOKCancel + vbDefaultButton2, "تأكيد") Then
Err.Clear
DoCmd.RunSQL "Delete * from [" & TableName & "] where n=" & ctl & ";"
If Err.Number = 0 Then
MsgBox "تم الحذف"
Else
MsgBox Err.Description, , Err.Number
End If
End If
ExitSub:
Set ctl = Nothing
End Sub
Database32_02.accdb