Roger's Download Samples - PrintOneLabel.mdb (intermediate)

Print Page | Close Window

PrintOneLabel.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=294
Printed Date: 14 Jul 2020 at 9:40pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com

Topic: PrintOneLabel.mdb (intermediate)

Posted By: Roger Carlson
Subject: PrintOneLabel.mdb (intermediate)
Date Posted: 28 Jul 2008 at 10:53pm

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

PrintOneLabel.mdb

This form illustrates how to print one label 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."

Download
Access 97 (33 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/PrintOneLabel97.zip - uploads/5/PrintOneLabel97.zip
Access 2000 DAO (44 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/PrintOneLabel2k.zip - uploads/5/PrintOneLabel2k.zip

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