jb7811
asked on
Multiple labels to match quantity?
I have an Access db set up for label printing for one of our customers. My label template is an Access report that pulls data from the database on to a 4 X 6 report template. My question is: If I have a quantity of 4 of a particular product being shipped out, is it possible to print out 4 labels and have a text field down at the bottom that says "1 of 4", "2 of 4", etc.?
The table I'm pulling the info out of is called "tblProducts", and the quantity field is labeled "Qty".
If anyone has any suggestions, I would greatly appreciate them!
The table I'm pulling the info out of is called "tblProducts", and the quantity field is labeled "Qty".
If anyone has any suggestions, I would greatly appreciate them!
ASKER
That's cool, but I need Access to see the quantity and then create 4 numbered pages. Can Access do that?
I guess I'm confused. Your template report prints out what now...just 1 page? with 4 labels on it...and you need 1 label on 4 pages instead?
ASKER
That's exactly correct.
IS there currently any grouping for your template?
Will each label be exactly the same? only you want 1 of, 2 of etc...?
try clicking on the detail bar of your report. Then in properties, set the Force New Page to "After Selection".
See if that gets it.
J
Will each label be exactly the same? only you want 1 of, 2 of etc...?
try clicking on the detail bar of your report. Then in properties, set the Force New Page to "After Selection".
See if that gets it.
J
ASKER
I don't believe there is grouping on the template, and yes, each label will be exactly the same. I'll try what you suggested. Thanks for hanging in there with me.
jb7811,
A few Questions:
So your system already prints the correct number of labels and you only need help getting "Label 1 of 4" to print on each label? Correct?
Does your System print All the Labels for All the Products, at the same time?
(Or, do you have to "Run" your system for each Product?)
Does your table look something like this:
ProductID LabelQty ShipToCountry
100 5 UK
150 2 USA
275 1 Spain
120 5 France
166 6 Germany
Access standard Labels print 1 label for each record.
Can you explain how your system takes the above table, and generates the correct number of labels?
Jeff Coachman
A few Questions:
So your system already prints the correct number of labels and you only need help getting "Label 1 of 4" to print on each label? Correct?
Does your System print All the Labels for All the Products, at the same time?
(Or, do you have to "Run" your system for each Product?)
Does your table look something like this:
ProductID LabelQty ShipToCountry
100 5 UK
150 2 USA
275 1 Spain
120 5 France
166 6 Germany
Access standard Labels print 1 label for each record.
Can you explain how your system takes the above table, and generates the correct number of labels?
Jeff Coachman
jb7811:
OK, I just read JeffW's post:
<Your template report prints out what now...just 1 page? with 4 labels on it...and you need 1 label on 4 pages instead?>
... and your Reply:
<That's exactly correct.>
… Ignore my post for now, let’s see what jefftwilley comes up with.
Jeff Coachman
OK, I just read JeffW's post:
<Your template report prints out what now...just 1 page? with 4 labels on it...and you need 1 label on 4 pages instead?>
... and your Reply:
<That's exactly correct.>
… Ignore my post for now, let’s see what jefftwilley comes up with.
Jeff Coachman
jb7811:
Can you post some data from your table here?
Or better yet, upload your database to:
www.ee-stuff.com
Jeff Coachman
Can you post some data from your table here?
Or better yet, upload your database to:
www.ee-stuff.com
Jeff Coachman
ASKER
This is some data from the table I print labels from.
ID|PO|ISBN|Title|PubDate|C ountry|USP rice|CANPr ice|Qty|We ight
6|123|978-0-9787320-5-9|Co lor Me Butterfly|2007|USA|22|37|1 1|11
7|555|978-0-9787320-5-9|Co lor Me Butterfly|2007|USA|23|32|4 |8
8|1234|717298100076|Hallma rk Keepsake Software|2007|USA|64|45|1| 2
Currently I click a button on the switchboard that says "Print Packing Labels". I am then prompted for the PO, which I key in, and then my report/label template pops up with all of the above info, except for ID, which is my primary key. Only one label comes up at this point. What I need to do is have whatever the number is in the Qty column to print that number of labels, or something comparable, and the labels need to be tagged "1 of 4", "3 of 9", whatever may be the case. I realize that this may be a lot to ask of Access. I've also uploaded a copy of the database. You guys are great, thanks very much.
ID|PO|ISBN|Title|PubDate|C
6|123|978-0-9787320-5-9|Co
7|555|978-0-9787320-5-9|Co
8|1234|717298100076|Hallma
Currently I click a button on the switchboard that says "Print Packing Labels". I am then prompted for the PO, which I key in, and then my report/label template pops up with all of the above info, except for ID, which is my primary key. Only one label comes up at this point. What I need to do is have whatever the number is in the Qty column to print that number of labels, or something comparable, and the labels need to be tagged "1 of 4", "3 of 9", whatever may be the case. I realize that this may be a lot to ask of Access. I've also uploaded a copy of the database. You guys are great, thanks very much.
ASKER
https://filedb.experts-exchange.com/incoming/ee-stuff/3035-BluSky.zip
This is the link to the DB. Please be kind to it. It is a simple Access database in a ZIP file.
This is the link to the DB. Please be kind to it. It is a simple Access database in a ZIP file.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
jb7811:,
OK I made one too!
:)
I used a loop to copy the record multiole times into a temp table.
Then based the report on the temp table.
I created a Menu so you can select the PO to print.
When you open the Report at the bottom of the label you should see:
"Page X of Y"
... printed correctly (and you can navigate through all the labels to view and verify them)
https://filedb.experts-exchange.com/incoming/ee-stuff/3039-BluSkyJC.zip
Hope this helps as well
Jeff Coachman
OK I made one too!
:)
I used a loop to copy the record multiole times into a temp table.
Then based the report on the temp table.
I created a Menu so you can select the PO to print.
When you open the Report at the bottom of the label you should see:
"Page X of Y"
... printed correctly (and you can navigate through all the labels to view and verify them)
https://filedb.experts-exchange.com/incoming/ee-stuff/3039-BluSkyJC.zip
Hope this helps as well
Jeff Coachman
Ooops!
I swear Jeff. I did the exact same thing as you!
I will look to see how you made yours!
:)
Jeff coachman
I swear Jeff. I did the exact same thing as you!
I will look to see how you made yours!
:)
Jeff coachman
lol...great minds
OK JeffW,
Your system is a lot more streamlined than mine.
;)
But it's funny that we both went the extra step of creating the menu.
Even our form name is the same!
I have more comments though
;)
I tip my hat to you!
I thought you were sick?
You are supposed to be in bed resting.
Pehaps I should collapse my lung, maybe, I'll get smarter too!
Take care!
:)
Jeff Coachman
Your system is a lot more streamlined than mine.
;)
But it's funny that we both went the extra step of creating the menu.
Even our form name is the same!
I have more comments though
;)
I tip my hat to you!
I thought you were sick?
You are supposed to be in bed resting.
Pehaps I should collapse my lung, maybe, I'll get smarter too!
Take care!
:)
Jeff Coachman
ASKER
Man, that's exactly what I needed. Your Genius rank is well-deserved. Many thanks from Tennessee.
JB,
Anytime...let us know if you run into any more problems.
JC,
I wouldn't recommend the collapsed lung thing...And I am resting until Monday when I go back to regular work. Too bad I couldn't make a living at this sitting at home in my pajamas drinking coffee!! :o)
J
Anytime...let us know if you run into any more problems.
JC,
I wouldn't recommend the collapsed lung thing...And I am resting until Monday when I go back to regular work. Too bad I couldn't make a living at this sitting at home in my pajamas drinking coffee!! :o)
J
<Too bad I couldn't make a living at this sitting at home in my pajamas drinking coffee!! >
Me too!
:)
Me too!
:)
="Page " & [Page] & " of " & [Pages]