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

Chapter 11. Enhancing Reports with VBA

Because of their rich printed view, reports have long been one of the more widely used features in Access. This chapter takes an in-depth look at reports in Access 2007. It starts from the beginning, so if you're already familiar with creating reports in Access, you might want to skip to the section "New in Access 2007."

The chapter also looks at several ways that you can enhance your reports by adding VBA behind them. You'll explore the various events that are available for reports and sections, and then move into some common uses for those events. Along the way, you'll see some issues that you should look out for as you're designing reports. Finally, you'll examine several new features in reports in Access 2007, including Layout view and Report view.

When you write code behind a form, there are certain things to consider, such as the flow of the application, searching for data, data entry, and validation. While reports in Access 2007 are still read-only, they have been greatly enhanced to allow for some of the form-type scenarios that you might have created in the past such as search, sorting, and filtering.

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