Repalce Access Dialog Boxes

[elliot315]

I have various forms that have a delete record command... how do I replace the dialog box that Access display with one of mine? and the other message that comes when there are no records for a query I put the cancel = true and a meessage comes saying "The Open Report Action was canceled"
I want to display my own and not the access defaults..

 

[RuralGuy]

You need to add error handling to your procedures.

 

[elliot315]

Ok... and that means?!?!!?
Im new in Access

 

[RuralGuy]

Here's a FREE AddIn for VBA and Access that many of us have installed. Among its many features, it can add error handling to a procedure with one key stroke. http://www.mztools.com/v3/download.htm You can also find out more about error handling by searching this forum. Post back if you need more assistance.

 

[elliot315]

thanks for your help, but as I told...I'm new in this scene so getting a new toolbar without knowing how to code is not an advantage, I'm not saying your effort has been ignored, I really aprreciate that, but I need clear instructions on how to do any procedure or how to write a code, is there any error number for the delete confirmation to turn it off and replace with one of my own? like
If error = ### then
MsgBox "MyMessage", vbyesno,
if Mymessage = vbyes then
delete record
else
cancel = true
something like that

 

[RuralGuy]

Let's see if an example from MVP Allen Browne will help here. The answer to your question is yes if you implement error handling.