08-05-2008, 07:56 AM #7 Steve_T Registered User Join Date: Feb 2008 Posts: 96 Thanks: 0 Thanked 0 Times in 0 Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals. To run a macro or event procedure when this event occurs, set the OnError property to the name of the macro or to [Event Procedure]. news In this example, if I leave the required field with no data, then click the Save button, then the Form Errors are not triggered, but instead, the sub procedure error that
Generally, you'll use it to redirect the flow, changing what happens after the Error event occurs. Domain Function Examples: Numbered Query With DCount So far in this series on Domain Functions, I've discussed the general syntax ( Domain Functions Demystified ) and problems involved in ... Currently, Susan volunteers as the Publications Director for Database Advisors. This is the reason why I also call this Button errors because most of the time (not all), I put sub procedure vba codes on the On Click event of a
Custom Error Messages in Access Expert 100+ P: 184 hyperpau Before anything else, I am not a very technical expert when it comes to VBA coding. We need to ensure that the event occurs when the users leaves the required field blank. First, because it looks more neat, and more importanly, If I would be changing an error message, or maybe adding a new DataErr, I would just have to edit the Public So i will create a new module and named it MyCodes.
More Importantly, I have like 20 forms that has a save button that does the same command and I do not want to copy paste the lengthy code to each of Sharon Williams General 6 12-12-2002 09:28 AM Form to let users create their own query Autoeng General 2 12-02-2002 08:58 AM How can I create custom labels Jeanette Reports 4 10-22-2002 Access will also create working space to manipulate data. Password Register FAQ Community Top Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find
Steve_T View Public Profile Find More Posts by Steve_T 08-04-2008, 11:20 AM #4 NigelShaw Newly Registered User Join Date: Jan 2008 Location: Leicester UK Expand|Select|Wrap|Line Numbers PrivateSubfrmMyForm_Error(DataErrasInteger,ResponseasInteger) MsgBox"ErrorNo.:"&DataErr EndSub The MsgBox will tell you the Error Number, and after clicking OK on that Message Box, the Default Error Message will appear. Tip If you're working with more than one version of Access, consider assigning error values to constants as follows: Const conRequiredValueError = 3314 Select Case DataErr Case conRequiredValueError ...action code... That TechRepublic Search GO CXO Cloud Big Data Security Innovation More Software Data Centers Networking Startups Tech & Work All Topics Sections: Photos Videos All Writers Newsletters Forums Resource Library Tech Pro