printout

[Guest]

Hello,
I created and Incoice form and a print command that prints the invoice to a
report. Is there anyway I can hit the print button once but print 3 copies?

Please Help Thanks

 

[Duane Hookom]

The common method involves creating a table of numbers [tblNums] with a
single numeric field [Num] and values 1 - some high number. Then add this
table to your report's record source and add the [Num] field to the query
grid. Set the criteria under the Num field to
Between 1 And 3
This will create three copies of each record/invoice.

 

[Guest]

Hello,

Thanks for the reply but I think I am kinda lost. Can you please breakdown
to smaller terms or is there any tutorial help on the internet to assist
further?

Thanks.

I must add that I saw where it can be done using a macro but my print
command is in VB may we can try combining both? What u think?

The common method involves creating a table of numbers [tblNums] with a
single numeric field [Num] and values 1 - some high number. Then add this
table to your report's record source and add the [Num] field to the query
grid. Set the criteria under the Num field to
Between 1 And 3
This will create three copies of each record/invoice.

--
Duane Hookom
MS Access MVP

Hello,
I created and Incoice form and a print command that prints the invoice to
a
report. Is there anyway I can hit the print button once but print 3
copies?

Please Help Thanks

 

[Duane Hookom]

Check the Better Solution at Allen Browne's page
http://www.allenbrowne.com/ser-39.html.

--
Duane Hookom
MS Access MVP

Hello,

Thanks for the reply but I think I am kinda lost. Can you please breakdown
to smaller terms or is there any tutorial help on the internet to assist
further?

Thanks.

I must add that I saw where it can be done using a macro but my print
command is in VB may we can try combining both? What u think?

The common method involves creating a table of numbers [tblNums] with a
single numeric field [Num] and values 1 - some high number. Then add this
table to your report's record source and add the [Num] field to the query
grid. Set the criteria under the Num field to
Between 1 And 3
This will create three copies of each record/invoice.

--
Duane Hookom
MS Access MVP

message

Hello,
I created and Incoice form and a print command that prints the invoice
to
a
report. Is there anyway I can hit the print button once but print 3
copies?

Please Help Thanks