If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > How do I print a full page of same label

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Feb 2002
Posts: 11
How do I print a full page of same label

I have a table with two fields. I want to print a full page of labels containing both fields for each record in the table. Is there a way to do this with the label wizard?
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Feb 2004
Location: Chicago, IL
Posts: 1,312
There are probably MANY ways to do this. But one way that I have used in the past is to create a table with x records in the table. Where x is the number of labels on a page. Assume there are 30 labels. Put 30 records in the table. The data that is stored in the table is irrelevant. I usually just put 1 to 30. Then create a query using the query designer. Add both tables to the query, then select the fields you want to show on the label. Make sure that there is no join between the tables.

The result of the query should be that each record from the table you want to use for labels is repeated 30 times. Then create a report that uses the query as the record source.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: May 2010
Posts: 601
Unfortunately the wizards do not handle this

Here is an example:

Print Multiple Labels
__________________
Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
Microsoft MVP - Access Expert
BPM/Accounting Systems/Inventory Control/CRM
Programming: Nine different ways to do it right, a thousand ways to do it wrong.
Binary--it's as easy as 1-10-11
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Feb 2002
Posts: 11
Great suggestion. It worked great! Thanks.
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: May 2010
Posts: 601
Glad you found a solution.

Would you mimd sharing what solution you used?
__________________
Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
Microsoft MVP - Access Expert
BPM/Accounting Systems/Inventory Control/CRM
Programming: Nine different ways to do it right, a thousand ways to do it wrong.
Binary--it's as easy as 1-10-11
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Feb 2002
Posts: 11
I used the method DCKunkle recommended. I created a new table with one field and added 30 records. Then created a query containing this new table and the one with my data. The query results contained 30 duplicate records of each record in my data table. Then I created labels with 30 per page. It was a great idea!
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: May 2010
Posts: 601
Quote:
Originally Posted by lpdds View Post
I used the method DCKunkle recommended. I created a new table with one field and added 30 records. Then created a query containing this new table and the one with my data. The query results contained 30 duplicate records of each record in my data table. Then I created labels with 30 per page. It was a great idea!
If you will check out the example I posted, it a solution using the basic method DCKunkle suggested, that shows a very flexible solution. It expands on the same basic principle of how to duplicate the records in a report without the manual effort. It will even allow one record to print a whole sheet and then next two records to each fill half the sheet. Or any combination needed.
__________________
Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
Microsoft MVP - Access Expert
BPM/Accounting Systems/Inventory Control/CRM
Programming: Nine different ways to do it right, a thousand ways to do it wrong.
Binary--it's as easy as 1-10-11
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On