O'Reilly logo

Access® 2010 Bible by Michael R. Groh

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

Chapter 10. VBA Programming Fundamentals

IN THIS CHAPTER

  • Working with VBA

  • Reviewing VBA terminology

  • Understanding VBA code basics

  • Moving from macros to VBA

  • Writing VBA code

  • Adding branching constructs

  • Understanding objects and collections

  • Understanding developer options

Most Access developers use macros now and then. Although macros provide a quick and easy way to automate an application, writing Visual Basic for applications (VBA) modules is the best way to create applications. VBA provides data access, looping and branching, and other features that macros simply don't support — or at least don't support with the flexibility most developers want. In this chapter, you learn how to use VBA to extend the power and usefulness of your applications.

Note

Use the database file Chapter10.accdb in this chapter.

Note

Although many readers of this book are experienced Access developers and are comfortable working with VBA, this chapter and the other chapters in this part of the book assume that you have no experience with VBA. I include these chapters to provide you with a firm foundation for many of the techniques I discuss in later chapters. As you'll see in Part III and beyond, many advanced Access techniques simply can't be implemented without the use of VBA code.

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