O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required