Printing a same label multiple x's on same sheet

[Guest]

thanks for the input, I do have an autonumber field and I can do the max to
that. for the print out 3x I have used VB but not a ton- do I tie an event
procured to the on click of the command button and what would the Print code
say to get 3 labels on the same sheet( 3label sheet)and not 1 label per sheet
3x

Thanks,
barb

 

[Guest]

hi again,
been a while. i almost forgot.
yes the button click event.
if you want 3 labels to print each time all the time then

Docmd.OpenReport "yourlabelreport", acviewnormal
Docmd.OpenReport "yourlabelreport", acviewnormal
Docmd.OpenReport "yourlabelreport", acviewnormal

there is a another way. by putting a text box on the form
for the number of labels to print. you could default it to
3.

Docmd.OpenReport "yourlabelreport", acviewnormal
DoCmd.PrintOut , , , , Me.txtQtyToPrint

but the last way may require input and is best if you need
to print different numbers of labels each time.

At some point the printer comes in to do the label feed.
access don't do that part.
good luck

 

[Guest]

hi again,
I told you wrong.
for three lables each time do this

Docmd.OpenReport "yourlabelreport", acviewnormal
DoCmd.PrintOut , , , , 3

the second way is still valid
sorry about that.
good luck

 

[Guest]

This works but it prints every record 3x. I only want it to print a report-
a label 3x same sheet for the ONE record that is currently displayed on the
form. I am using the textbox where the #labels defaults to 3. or they can
put own in obviously.

Thanks for your help,
Barb

 

[Guest]

Sorry one more thing when I press the print label command button with the
code below. It also prints every record in the current form I am on. I only
want the label report to print NOT the FORM record(s)
Thanks

 

[Guest]

ONE MORE thing- yeah sure.

I tried the max for the RecID to only print out the last record. It prints
the last record entered but not really what I want. On the form I would
acutally like if they press the PRINT LABEL button for it to print 3 copies
of the label-really 1sheet for that SPECIFIC record that is currently
visible????? not always the last record entered.

Please help asap -needed this done yesterday of course????
Thanks,
barb