Jul 21 2005, 11:52 AM
I'm trying to create a small database that will create chart lables for patient chart.
I need it to be able to print 3 labels at the time for a patient on 1 x 4 inch labels that are 2-up/2-across on a sheet.
Is there a way to do a report like this? I can get the data in, but not sure on how to make the report to repeat the record .
Jul 21 2005, 11:56 AM
In the form design you can set up all 3 labels on 1 report and put the field in 3 times, however this will waste 1 label per sheet
Jul 21 2005, 12:12 PM
But with them being two per row, then if i do three, unless i can start the 2nd record in the 2nd label on the 2nd row, then i'm wasting 5 lables per page or one every other row.
Jul 21 2005, 12:22 PM
Sorry, I misread the 2-up/2-across thinking that the label sheets were only 4 labels per sheet.
Ok then how about turning the label sheet over and inserting so the report prints on the unused labels 2nd pass (this would leave 2 labels unprinted) - surely these could be used for something if left in a spare box?
Jul 21 2005, 12:43 PM
There are 20 labels per sheet, and i wish the customer i have would just use 4, that would be easy to fix, but they don't want to do that, they want 3, so i'm trying to get the most labels on a sheet that I can.
If i do, 2 labels on the first row, then 1 on the second row, then go to the next row, then i will waste 5 lables per sheet,
If i can start the 2nd record on the 2nd row, 2nd label, then i'll lose 2 per sheet.
Jul 21 2005, 02:04 PM
Some one, I think it was Peters Software had a utility to print unused lables which might work for you. I checked the LinkDb but his link isn't working. maybe do a search on Google for his site.
Jul 21 2005, 02:51 PM
I have used this code to do what you want: Skip used labels and print duplicate labels
There is a link there to an access 97 reports sample MDB with the code.
Jul 21 2005, 04:00 PM
That was the code I was thinking of.
Thanks for the link.
Jul 24 2005, 04:17 AM
Glad I could help.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here