So here are the remaining 3 (of 7) reasons why you should use Access database VBA in your application.
- Manage more powerful procedures that Microsoft Access macros lack or is limited by creating references and links with other proccesses including custom built functions.
- Allows you to communicate with other applications and across platforms increasing the seamless power of Access VBA (Visual Basic for Applications).
- You can gracefully handle errors (if or when they happen) and will happen from time to time allowing you flow and manage unexpected exceptions (errors) allowing code to continue and flow.
To view the first 4 reasons, take a look at my previous part 1 post.
7 Reasons Why You Would Use Access Database VBA In Your Application – Part 2 of 2
You do not need to be a programmer to learn Access database VBA (but it helps if you have some knowledge).
The more important factor in order to successfully program with Access is to be knowledgeable within the framework of Microsoft Access generally (namely tables, queries, forms, reports and macros) and know its powerful features to identify where VBA should take over and improve the functionality.
I invite you to keep up to date with my articles and eBooks which cover a lot of details and you can find out the basics of Microsoft Access Database VBA Programming here.
Tags: access database vba, access vba, microsoft access programming, programming with vba, vba help