A strong knowledge of the VBA language is imperative for an Access developer. This hour covers all the basics of the VBA language. You have learned the differences between Code, Form, and Report modules and how to effectively use each. You have also learned the difference between event procedures and user-defined subroutines and functions. So that you can get the most mileage out of subroutines and functions, you have learned how to pass parameters to and receive return values from procedures.

You use variables throughout application code. Declaring each variable with the proper scope and lifetime helps make an application bugproof and easy to maintain. Furthermore, selecting an appropriate variable type ensures that the variable consumes the minimal amount of memory and that an application's code protects itself. Effectively using control structures and built-in functions gives you the power, flexibility, and functionality required by even the most complex applications.


For more information about the VBA language and programming in Microsoft Access, consult Alison Balter's Mastering Access 2003 Desktop Development and Alison Balter's Mastering Access 2002 Enterprise Development, both published by Sams Publishing.

    Part III: Creating Your Own Database and Objects
    Part V: Advanced Topics