Create CUSTOM ERROR MESSAGE containing "OK"  BUTTON that causes the private subroutine to abort after <br><br>user clicks on "OK"

Hello everyone,

Here' s the problem that I hope someone can help me with.

I Have a command button on a  SUBFORM that appends the selected  record to a particular table and then deletes the record from the source table. Whenever the button is used the following series of Access's default messages come up giving you the options to continue "YES" or "NO":


1.     You are about to run an append query…. (Replace with: "Do you want to remove…?")
2.     You are about to append 1 row(s)…        (Replace with: "You are about to remove…")
3.     You are about to delete 1 record(s)...       (Replace with: "Are you sure you want to remove…? ")

I would like to change these messages as indicated above.  But keep the "YES - NO" buttons in the message box.
-------------
ALSO
-------------

There is also a lenthy default error messages that arises relating to the Append Command when the user forgets to fill in the date field in the SUB FORM  because that field  is a required field in the table that is being appended.

I would like to change this error message to :  "You must enter a date…".
AND cause the ENTIRE PRIVATE SUB to abort after the user clicks OK.
I don't want the user to even get the option to delete the record if it can't first be appended!!!

Can an expert PLEASE show me how to include this into the code behind my command button?
The code behind my command button is as follows.

Private Sub cmdRemove_Click()
On Error GoTo Err_cmdRemove_Click

    Dim stDocName As String

    stDocName = "qryAppend"
    DoCmd.OpenQuery stDocName, acNormal, acEdit


    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

Exit_cmdRemove_Click:
    Exit Sub

Err_cmdRemove_Click:
    MsgBox Err.Description
    Resume Exit_cmdRemove_Click
   
End Sub


Thank you for your help.