Prevent Action Failed Dialog from Popping up-Macros

[conda_cole@hotmail.com]

I am new to creating databases and I have created command buttons that runs macros. Lets say I double click a button that I only wanted to click once. For example if I click my save button More than once, I get an action failed box. With an option to halt. Well I want the Action Failed box to stop popping up. I would like to have the macro automatically halt. I am going to present this database to people and I dont want them to get that halt or step into dialog everytime they click something they cant do right then. I have created some message boxes that just have ok buttons, but they pop up in addition to the action failed. I want just the message box to come up. I tried setwarnings property to False that did not stop the action failed.

Thanks for your expertise

 

[icusawme]

Try something like this

Private Sub Your sub name here (DataErr As Integer, Response As Integer)
On Error Goto YourErrorHandler

What you want to happen goes here

YourErrorHandlerExit:
Exit Sub
YourErrorHandler:

Response = acDataErrContinue

Resume YourErrorHandlerExit
End Sub

This should suppress errors, the problem with this is it will suppress errors that you may need to see during development.

 

[icusawme]

After review of my response I realized I may have given too much info, I would suggest using the following part of the first response

YourErrorHandlerExit:
exit sub


YourErrorHandler:

What ever else you need in this errorhandling section

Resume YourErrorHandlerExit

Likely may be happening is your error handler is sending your error back up to where the error occured causing a double report of said error. I hope this helps