Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-07-2019, 05:02 AM   #1
m2boost
Newly Registered User
 
Join Date: Nov 2019
Posts: 8
Thanks: 4
Thanked 0 Times in 0 Posts
m2boost is on a distinguished road
Print multiple label base on a table field qty

Hi all,

I had never done something like this and looking for some help.

I have a Table ([tlbStickerData]) that contain a field ([Nest Qty]) and I'm looking to print a label report ("LblStickerData") but my output to be base on the [Nest Qty] from my table.

I have all the format on my label done and I can printed but if the [Nest Qty] in my table is 2 I like the output to be 2 labels for that line of data in my table.

Any help will be appreciate!

Thanks,

Ernie

m2boost is online now   Reply With Quote
Old 11-07-2019, 05:37 AM   #2
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,224
Thanks: 92
Thanked 2,023 Times in 1,971 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Print multiple label base on a table field qty

See if this material helps and/or could be adapted.
You should avoid embedded spaces in field names --they will lead to syntax issues. Use only alpha/numerics (and "_" if needed) for names.
Good luck.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is online now   Reply With Quote
Old 11-07-2019, 06:13 AM   #3
m2boost
Newly Registered User
 
Join Date: Nov 2019
Posts: 8
Thanks: 4
Thanked 0 Times in 0 Posts
m2boost is on a distinguished road
Thumbs up Re: Print multiple label base on a table field qty

That's perfect and simple! Thanks for the help jdraw!!!!!

m2boost is online now   Reply With Quote
Old 11-07-2019, 06:18 AM   #4
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,224
Thanks: 92
Thanked 2,023 Times in 1,971 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Print multiple label base on a table field qty

10-4 Good luck with your project.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is online now   Reply With Quote
Old 11-07-2019, 06:38 AM   #5
m2boost
Newly Registered User
 
Join Date: Nov 2019
Posts: 8
Thanks: 4
Thanked 0 Times in 0 Posts
m2boost is on a distinguished road
Re: Print multiple label base on a table field qty

Thanks again jdraw, it was the last piece to the puzzle that I was missing.

The DB just take a data dump (CSV) files and import them into a table on access then remove the CSV files from my network drive. I using that data to generate labels but as part of the data it tell me how many pieces they are, that's where I was need to print a label for each pieces

All working like a charm now... thanks for the info!

m2boost is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
1 field value print several text box or label meenctg Reports 4 12-09-2013 08:50 PM
Making a report the size of a specific label and print on that label. parkerjallen Reports 1 11-17-2012 05:44 PM
Print individual label multiple times jasony Reports 1 08-08-2011 02:07 PM
Queries criteria base on Table field denthui Queries 8 09-01-2009 11:34 PM
Multiple Print, label change GUIDO22 Reports 0 10-12-2006 12:07 AM




All times are GMT -8. The time now is 08:20 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World