Multiple mailing labels for single records!!!

[Cocis91]

I have no problem creating a mailing labels report which produces one label for each record in the query. However, the query contains a field that has on it the desired number of labels for that particular record. How do I amend the labels report or create a new labels report that produces a number of labels for each record according to the number required? I have racked my brains and cannot get this sussed!!!!!

 

[ChristopherM]

You should be able to use PrtDevMode to change the number of copies/labels - see the example under Access Help

 

[Chris RR]

You could also go to the Microsoft site & look up article Q95806. This article shows how to set up a little routine that lets you skip blank labels at the beginning of a sheet (which you don't need) and how to print multiple copies, prompting for the number needed (which you could probably adapt?)

The microsoft site is: http://search.support.microsoft.com/kb/c.asp

 

[Cocis91]

Thanks for the responses. I solved the problem with the use of the code that can be found at: http://support.microsoft.com/support/kb/articles/Q95/8/06.ASP?LN=EN-US&SD=gn&FR=0

This code is intended for producing a specified number of labels for a print job where you are only printing one kind of label. However, I wanted to print mailing labels for a number of records returned by a query. The query had in it a field that stated the number of labels required for each particular record. Hence, I included this field in the labels report at the bottom of the address as a non-visible field (I named it "LabelsRequired").

I was then able to adjust the code for the Microsoft website so that instead of it asking for the number of labels required and applying this to every rcord in the details section of the report, it instead picks up the required number from the hidden field in the report. I made it pick up this value by putting "LabelCopies& = Reports!MyLabels.LabelsRequired" in the Label Layout function. It works perfectly.

 

[randyman65]

I trie the approach method that Cocis91 used, referring to a field name on the report rather than the value in an input box.

Unfortunately I keep getting a run time error (2427) when I do this. My knowledge of the code in access is limited so I can't identify where my error is coming from.

How would I specifically substitute the value from a field on the report for the value obtained from an input box on the sample code from ms?

 

[ANDREW_SAUNDERS]

can anyone resolve the cause of the runtime error?