Need help with page of labels

[AGM2004]

I need to be able to print a page of labels (all EXACTLY THE SAME) --3 across & 10 down (Avery 5260 or Maco ML-3025).

I KNOW Access2000 can do this, because in the NORTHWIND example it does it (except each label is different).

I have set up the label, but can only get it to print a SINGLE label. HOW can I tell it to print all 30 labels.

PLEASE HELP---I've searched forum, looked throughout the NOrthwinds sample, but can't find the way to designate this--

Thanks in advance for your help!

 

[statsman]

Lets start with the obvious...did you select the correct type of label from the wizard?

 

[AGM2004]

I had to create a label for 3 accross as my wizard didn't give it as a selection.---However, I never found a place to indicate 10 rows.

 

[statsman]

If you go back to the report wizard. On the first screen select the label wizard. Also select the table/query that contains the required data.
The next screen will request the type of label. Choose "Avery" and then select "5260". You will note that the wizard gives you the size of each label and the number accross. To the best of my knowledge you can't select the number down. You should know the number of labels that will be printed. If Avery 5260 had more than 10 rows of labels, you'll have some leftovers. If Avery 5260 has less than 10 rows, you'll need 2 sheets.
You can of course create labels in code, but the wizard is so much easier.

 

[AGM2004]

Thanks for your help....
The problem--if the "Metric" button is clicked--it won't show the Avery 5260....

BUT--It doesn't make any difference....It still only wants to print a SINGLE label---The same as my "Custom" label did.

AND If I tell it to print "3" (File, Print...) it prints 3 pages of a single label in top left corner.--Still not what I need.

Any other thoughts?

 

[statsman]

Now that I understand the problem, I can't think of a way to do this except by means of customizing.
You could of course use the Label Wizard with Mail Merge in Word. This not only allows you to print single labels but also allows you to determine where on the sheet of blank labels to print it (ie. you have only on label remaining on the top row, you can tell Word to print it there - saves a lot of wasted labels).
If the table has a unique identifier for each record, you could make a query to prompt you for the one you wish to print and Mail Merge it to Word.

 

[AGM2004]

Thanks for your help! I don't feel soooo bad for asking the question since it's not something obvious that I just missed.

Has anyone else had any success with this?


Thanks!

 

[KenHigg]

Is this a one time deal or will you always want to print an entire page of labels at a time?

kh

 

[AGM2004]

We will ALWAYS want to print a full page of the same labels at at time...

The label fields are populated by specifying an ID number, which fills in names, age, and other assorted fields, but we need 30 of each label each time.

 

[KenHigg]

Failing to come up with any other solution, could you make a table to use as a print buffer where you append 30 records with the exact same info, then use this table to drive the label print job?

kh

 

[statsman]

The label printer in Word will let you print an entire page of the same label.

 

[AGM2004]

THANK YOU both for your input.

You were most helpful.