By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,489 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,489 IT Pros & Developers. It's quick & easy.

Print same Reciept 3 times on a Page

P: n/a
Hi,

I have an Access 2003 db that is used to enter parking ticket info when
the ticket is paid. The data is entered via form, and on that form is
a command button that prints the Receipt Report for the current record.
That works fine. However, I need to have the receipt repeat itself a
total of 3 times on the printed page (8.5 x 11 sheet, perforated twice
at 3.23in). I added this bit of code (below) that I found on this
newsgroup and it does print the report 3 times, but on 3 individual
sheets, which is not what I need. I need it to print the report 3 times
on the same page. Any help is appreciated...thanks!

Private Sub Command32_Click()
On Error GoTo Err_Command32_Click

Dim stDocName As String
Dim iCounter As Integer
For iCounter = 1 To 3
stDocName = "rptParkingTicketReceipt"
DoCmd.OpenReport stDocName, acNormal
Next

Exit_Command32_Click:
Exit Sub

May 10 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
AP
Maybe try making 3 copies of the report (with a different name) and
embedding them as subreports on an unbound report?

May 10 '06 #2

P: n/a
Hello,

If the data is to be the same everytime on the
report, why not just put the same controls on
the report three times into the locations they
need to be?

Just another two cents worth.

Regards

May 10 '06 #3

P: n/a
Thanks for the idea! I think that will work.

May 10 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.