• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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 LawTrack Contacts sample application (Contacts.mdb). 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 in the Select Contacts pop-up window. Perform a search for all contacts who own the Single User product—you should find four records in the original sample data. Click the Print button on the frmContacts form, select Avery 5163 Labels (2” x 4”), ask for the report to include the Displayed Contacts, and specify that your first page of labels is missing three used ones. Your screen should look like Figure 23-27 at this point.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint