Summary


This chapter aims to equip you to create static and dynamic reports by building on your knowledge of forms and their controls, report wizards, Access report architecture, and VBA collections, such as Reports and AllReports . Your applications can manage the controls on a report with the same set of properties for forms. In addition, this chapter demonstrates how to use a form as an interface for customizing the design of a report. This latter application type can create dynamic reports that adapt to user actions at run time.

While you can control the design of reports programmatically, just as with forms, with reports you are more likely to use the rich collection of built-in wizards for quickly creating the base version of a report. Then, if necessary, you can customize the report at design time or run time. It is also common to use Design view to manually construct Access reports. This process benefits from an understanding of Access report architecture, including the standard and custom report sections that you can create along with the sorting and grouping rules that you can specify for a report.

Although programming a report from scratch can be tedious , automatically modifying a manually created report via one or more procedures can be powerful and relatively easy. You can save and send reports as snapshot files with simple VBA procedures. In addition, you can readily customize the formatting of reports by showing values in different colors, and at run time you can even set which values receive which colors. Another typical programming application is to assign the record source for a report dynamically. Reusing the same report with different record sources can make your applications easier to manage by reducing the total number of reports. After you have a collection of reports in the current database file (or even another one), you can programmatically inventory and manage your reports through the AllReports and the Reports collections.




Programming Microsoft Office Access 2003
Programming MicrosoftВ® Office Access 2003 (Core Reference) (Pro-Developer)
ISBN: 0735619425
EAN: 2147483647
Year: 2006
Pages: 144
Authors: Rick Dobson

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net