Prompt Pop Up Alert Message on clicking Form Button

[Alexandru Human]

Hi guys!



I am new to this wonderful DB program - MS Access 2013.
A week ago I decided to create a Data Base for my company. So I decided to study Access using the Internet.
Having learned some things about it, so I could create tables and forms, I learned to add various buttons in Forms.

However, I do not want my employees to click those buttons unintentionally, especially when it come to the Delete Record button.
This is why I would like my Delete Record Button to prompt a Pop Up Message saying: "Are you sure you want to delete the record?"

I will be extremely thankful if you guys could teach me how to do it.

Peace in our time!

[pbaldy]

Here's my template code for a yes/no message box:

Dim msg As String, button As Variant, title As String, response As Variant

msg = "Vehicle is Shopped - Do you want to dispatch anyway?"
button = vbYesNo + vbDefaultButton2
title = "Vehicle Shopped!"


response = MsgBox(msg, button, title)
If response = vbYes Then
  'what to do if yes
Else
  'what to do if not
End If

[Micron]

There may be other things you'd want to consider, such as restricting the ability to delete records to groups or employee levels (perhaps by way of disabling buttons). Also maybe ensuring your db is backed up nightly on the network in case you need to fall back. I say this because in my experience, people just don't seem to pay attention to these prompts. Perhaps it's because they're rushed, or inundated with program prompts from other applications, or maybe it's just the crowd I used to work with. They'd constantly amaze me when having issues and I had to ask why the heck I bother putting those in if they're not going to read them. So just saying, it's not foolproof, and if it's very important, you more robust deletion prevention. Maybe tracking who deletes or edits important records too.

If the idea of a message box still appeals to you, maybe check out the message box function in the object browser or help files so you can learn more about the button types and warning levels. I usually don't use the Else flow for a two possibility situation since if it is not the first, it is automatically the only other option. It's just a matter of style, and for me, writing less code when I can. Nothing wrong with having it either.