Multiple copies of same mailing label

[CherylF]

Hello

I am interested in using the label report to create mailing labels. The only problem is that I need more than one label printed at a time for the same address. I seem to be able to only get one label at a time.

Any suggestions?

Thanks

 

[Jay/UK]

I TOO would like to know how to do this.

I know how to do it in Word which has a pre-defined feature for this.

I hope to see the replies to this topic.

Kind Regards,
Jay/UK

 

[CherylF]

Someone helped me with this problem. The way to solve it is:
Once you have created your label report, under FileageSetup. There is an option that permits you to tell the program whether to print the labels "down and across" or "across and down". The default is "down and across", you need to change that to "across and down". When you are creating your label report you must have the number of labels per event (e.g. Survey ID numbers) to create the number of labels you want.

Cheryl

 

[Ron Bell]

I'm interested in this!! But-
CheryIF: Please explain further your last sentence of posted 07/28/200 08:28
Where are you entering this ID number for number of labels required?
I can't find this option in the Access2000 Wizard, ie "number of labels per event"

 

[CherylF]

Hello

There is no option to specify the exact number of labels you require. When you are creating the label report you will need to place the number of fields (e.g. ID numbers) that you require into the report. So for example, I required 8 individual labels with the same ID number. When creating the label report I used the wizard to create the initial report (with one copy of the field). I then highlighted the field, copied and pasted the field so I had the required number of copies. I then moved the fields so they would print on the labels in the correct place. Once this is done you go into the PageSetup option and change the default from "across, then down" to "down, then across".

I hope this helps.

 

[Ron Bell]

Hi "CheryIF"

Thanks for your clear reply - much appreciated.

I'm wondering if users may be able to set number of labels required.
This may be achieved (I'm working on this one) via say:-
Reset report to a single ID.

create a new table just for 'numbers of' report/labels, with required fields + new Date/Time field.

If then, on a form users can enter via a textbox or combo, the number required

A public variable is set to required number in textbox/combo = 'X'.

A command button then has On_Click event to run code - outlined below:
Button would then OpenRecordset = (Original Reports recordsource - Query/Table)
Then Loops thru the ID's
Dim Y = Now()
In Loop -
Adds to new table 'X' number of required ID records (+ other stuff, + Y to new Date/Time field) to each row,
- via another Recordset Loop
Then - open report using OpenReport method

The Date/Time would act as a index and criteria for the reports' query result - ie Max(Date/TIme)
The report would run from a new query which includes new table, using the Max of date/time field.

Just an idea - not tested - but would, when successful, be more flexible to users. ie they can enter number of labels required

Downside:
(1) new table to manage
(2) Loops in VBA recordsets may slow things down.

What do you think???



[This message has been edited by Ron Bell (edited 08-13-2000).]

 

[Jack Cowley]

This article will give you the code and show you how to print multiple copies of the same label.
http://support.microsoft.com/support/kb/articles/Q95/8/06.ASP?LN=EN-US&SD=gn&FR=0

HTH,
Jack

 

[CherylF]

Hello Jack

I have printed off the report that you suggested, but I seem unable to make it work. In step 3 of the report it talks about an OnOpen property of the label report. I am not able to locate this under the property function. I have also downloaded the sample report from the website. This has the coding in it. I copied the coding and set it up exactly like Microsoft. Unfortunately I seem to be doing something incorrectly. In ONPRINT I have the following typed in:
=LabelLayout([Reports]![Labelsfile1])

I am only getting one label to print out and it is not allowing me to skip labels or print multiple copies.

Help please