In the first shot we can see that the code I have entered into my macro stopped the user from sending off null data to the database. Below we can see the code I have entered , plus the error message box to stop the user from doing this! "IsNull" states that if the field name is empty then the error message I set up will pop up and data will not be appended to my tables.
Below we can see a validation rule I have entered for age. This is the error message I have set in place for underage users and older age users to stop them from entering the database.
No comments:
Post a Comment