Trapping messages with code

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

How do I trap Access messages with code and substitute my own? I am trying
to work out how to trap the delete record confirmation messages, the one
that asks the user if they are sure and then the one that mentions other
tables where there is a relationship. These are not user friendly and I want
to put my own messages there. I know I can stop them altogether from
Tools/Options but I don't want to stop all messages.
Anyone help?
PS I'm a newbie at VBA so I would be grateful for easy steps please

Tony Williams
 
DoCmd.SetWarnings False
Msgbox "Your message"
<<Your delete Code>>
DoCmd.SetWarnings True
 
Sorry figured it out I've put it in the procedure behind the delete button!
Obvious really.
Tony
 
Back
Top