Access Database Development Tips: For Beginner to Intermediate Access Developers by Brent Jones

Author:Brent Jones [Jones, Brent]
Language: eng
Format: epub
Published: 2018-07-14T23:00:00+00:00

On Error Resume Next: This line is your best friend. It sets up the error handling magic in the background and tells Access to skip over any errors it comes across. Normally this goes towards the beginning of your code or at least before most it. If you have any loops, this line should go before the loop initializes.

If Err.Number <> 0 Then: Technically you don’t need this part. But it’s not a bad idea to tell Access what to do if it catches any errors. Each type of error has a numbered index attached to it. So, if the error number is zero, that means there are no errors. If it’s anything other than zero, there was an error somewhere. Access has a reputation for giving vague error messages. Let’s be nice and give our users a more informed message for any potential errors. If you want to use Access error message, you can use Err.Description. We use Err.Clear to remove any errors from the error object.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.