The Ten Commandments of VBA for Microsoft Access Newbies: Practices that produce safe, understandable, and reliable software

THE FOUNDATION FOR VBA SUCCESS Many VBA books try to tell you everything you can do with the language. Many succeed, but they are very large, because VBA is large. You will need large books eventually. But while large books tell you what you can do, this book focuses on what you should do. What you should do is a much smaller subset of VBA, so your learning is faster. And, when you get to the large books, you’ll already have a good foundation. THE READER Is working with an Access database Needs leverage over Access Wants the most power with the least effort The text is aimed at readers who have a little bit of programming experience. Of course, experienced developers are also welcome. WHAT YOU’LL LEARN The small set of VBA you need The proper way to write VBA code Where to put your code Where not to put your code How to equip VBA with safety code How to find errors before they cause problems How to use Tools to simplify development WHERE THE COMMANDMENTS COME FROM The techniques presented in the book have been developed over several decades.They’ve been successfully used with VB, Fortran, Pascal, C++, C# and other programming languages. They’ve been used to design, develop, maintain, and extend software used in the scientific research of structures responsible for protecting human life.