Microsoft Office® Access 2007 Inside Out

Automating Reports

In a typical application, you’ll probably spend 80 to 90 percent of your coding effort in event procedures for your forms. That doesn’t mean that there aren’t many tasks that you can automate on reports. This last section shows you just a few of the possibilities.

Allowing for Used Mailing Labels

Have you ever wanted to create a mailing label report and come up with a way to use up the remaining labels on a partially used page? You can find the answer in the Conrad Systems Contacts sample application (Contacts.accdb). Let’s say you want to send a promotional mailing to all contacts who own the Single User product offering them an upgrade to Multi-User. Open the main switchboard form (frmMain), click Contacts, and then click Search ...