Print Page | Close Window

PrintMultipleLabel.mdb (intermediate)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=295
Printed Date: 22 Nov 2019 at 3:48pm


Topic: PrintMultipleLabel.mdb (intermediate)
Posted By: Roger Carlson
Subject: PrintMultipleLabel.mdb (intermediate)
Date Posted: 28 Jul 2008 at 11:03pm

Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .
 

PrintMultipleLabel.mdb

This form illustrates how to print multiple labels which matches the value of the record in the form. The code is behind the 'Print Report' button and basically creates a query: 'qryMyQuery' which is the Record Source for the report and then opens the report in preview mode

To print multiples, the sub 'CreateLabelNum' deletes then fills the table 'tblLabelNums' with the number of records in the combo box. This table is then joined to the main table WITHOUT indicating a Join field. This creates a cartesian product which will join each selected row with a row in the tblLabelNums table.

Download
Access 97 (26 KB):
http://www.rogersaccesslibrary.com/forum/uploads/5/PrintMultipleLabel97.zip - uploads/5/PrintMultipleLabel97.zip
Access 2000 DAO (41 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/PrintMultipleLabel2k.zip - uploads/5/PrintMultipleLabel2k.zip



-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window