Save Record built-in macro with custom confirmation dialog

JakeChampion

New member
Local time
Today, 17:50
Joined
Feb 4, 2012
Messages
1
Hi, I was wondering if anyone knew how to create a custom message for the save record confirmation, only using macros and not user coded VBA. I've done this for a previous project in VBA but this time I'm trying to only use Access' macro builder. I'm using Access 2010 to build this project.

So far I've used
IF 6=MsgBox("Are you sure you want to delete this customer's information? WARNING, this is unrecoverable."),52 Then
RunMenuCommand DeleteRecord
MessageBox Message "Customer information deleted."

This makes a yes no dialog box first as the confirmation but it then shows the built-in confirmation that Access bundles with the DeleteRecord command. I searched the macros thread here but couldn't see it posted. I'm grateful for any help I receive.

Thanks,
Jake.
 
If you want to supress that prompt, you need SetWarnings.
 

Users who are viewing this thread

Back
Top Bottom