Printing a same label multiple x's on same sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
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
 
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
 
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
 
Back
Top