O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

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

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 next 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 ...

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