Need warning msge before deleting record

G

Guest

I have used the built-in Delete Record command button to enable users to
delete certain records, but I would like to add a popup that says "Are you
sure you want to delete this?" with Yes/No options.
I'm sure I've seen how to do this somewhere - is it a dialogue box that I
need? - but (i) how do I do it? and (ii) on which event do I put it, as the
On Click event is already in use to fire the deletion process.
Or do I add some extra code to that existing event procedure?
Need some guidance on this pleas!
Many thanks
CW
 
G

Guest

Access should already be doing this automatically UNLESS someone has Set
Warnings off in a macro or code. Once the warnings are turned off, they stay
off unless you (1) turn that database off and back on or (2) SetWarnings to
True after what ever you were doing where you wanted the warnings off is
complete.

Often people use code to do things like update or append queries and they
turn off the annoying "do you really, really want to do this" message. Then
they forget to set the warnings back on at the end of the macro or function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top