Access™ 2007 VBA Programmer's Reference

13.12. Summary

This chapter took you on a whirlwind tour of the object-oriented programming techniques that are made available in Access 2007. If you had any trouble understanding the concepts, just remember that it may just take a little practice. Before long, you'll be writing quite complex OOP code that will make your application development and maintenance a joy to behold.

Specifically in this chapter, you looked at class modules, how they differ from object instances, and when you would use OOP techniques in your applications. You created several classes of your own, designed their properties and methods, and instantiated the classes as objects to investigate how they work and how to use them.

You learned about the object naming strategy, and then you examined class events and errors, to understand how classes communicate with the outside world. You also practiced using forms and reports as objects, and explored collection classes, which are the basis for building your own object models. Finally, you looked at some basic OOP theory and saw how to implement some of it in code.

You have now gone as far as standard VBA can take you. Chapter 14 starts you on the next leg of your programming journey by introducing the Windows API and the many built-in functions that the Windows operating system can offer in terms of advanced programming functionality.