468,291 Members | 1,436 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,291 developers. It's quick & easy.

"You are about to delete one message"

1
hey people, can you help me out here. How do i replace the message that is produced by MS Access when you click the delete record button. The message "You are about to delete one message"
I would like to replace this message with my own, how does the coding of this go by?????

help!!!!!!
Jun 16 '07 #1
1 3160
ADezii
8,799 Expert 8TB
hey people, can you help me out here. How do i replace the message that is produced by MS Access when you click the delete record button. The message "You are about to delete one message"
I would like to replace this message with my own, how does the coding of this go by?????

help!!!!!!
  1. In the Click Event of your DELETE Button:
    Expand|Select|Wrap|Line Numbers
    1. DoCmd.SetWarnings False
    2.   DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    3.   DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
    4. DoCmd.SetWarnings True
  2. In your Form's Delete() Event:
    Expand|Select|Wrap|Line Numbers
    1. Private Sub Form_Delete(Cancel As Integer)
    2. Dim Msg As String, intResponse As Integer
    3.  
    4. Msg = "Are you sure you want to DELETE this Record?"
    5. intResponse = MsgBox(Msg, vbYesNo + vbDefaultButton1 + vbQuestion, "Delete Confirmation")
    6.  
    7. If intResponse = vbYes Then
    8. Else
    9.   Cancel = True
    10. End If
    11. End Sub
Jun 16 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

10 posts views Thread by solosnake | last post: by
4 posts views Thread by J. Campbell | last post: by
3 posts views Thread by maadhuu | last post: by
2 posts views Thread by Bob Tinsman | last post: by
30 posts views Thread by Medvedev | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.