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.
Printed Date: 19 Sep 2020 at 8:25am
Software Version: Web Wiz Forums 12.03 -

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, - find out why here .


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.

Access 97 (26 KB): - uploads/5/
Access 2000 DAO (41 KB): - uploads/5/

Consider donating $1 per sample downloaded," rel="nofollow - find out why here .<

Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 -
Copyright ©2001-2019 Web Wiz Ltd. -