Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / June 2007

Tip: Looking for answers? Try searching our database.

Custom error messages

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mike - 05 Jun 2007 21:22 GMT
Is there a way of overriding certain Access error messages with my own? I
know you can do it at the form level, but is there a way of just
saying..."anytime this error ever comes up, bring up my custom error
message." The reason is b/c I have a lot of forms and buttons and everytime I
want to alter one of my custom error messages or add a new one, I have to go
into all of my forms and all of my buttons to do so....

Thanks for the help!
Larry Daugherty - 06 Jun 2007 04:24 GMT
No.

The trick is to generalize and then localize the messages in your own
error handlers so that they give you not only the general error
message but also any specific information you might want.  It isn't
too difficult to put a select statement in your error handler that
causes different messages for different errors - all from the same
error handler.  Also, you can insert the procedure name in the error
message..  Don't overload your poor users with noise.  You can also
put in conditional flags for "terse" for normal running and "verbose"
for development.

Have you tried MZ Tools?

HTH
Signature

-Larry-
--

> Is there a way of overriding certain Access error messages with my own? I
> know you can do it at the form level, but is there a way of just
[quoted text clipped - 4 lines]
>
> Thanks for the help!
Michael - 08 Jun 2007 14:20 GMT
So basically I just have to go into every form's error handler code, every
submit button, every exit button and every clear button and paste in the same
code?

No, I don't know what MZ Tools are!

Thanks for the help
Signature

Michael

> No.
>
[quoted text clipped - 22 lines]
> >
> > Thanks for the help!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.