Multiple Copies of Report Print!

RichB · Jan 21, 2004

I have a report that I print from a button on a form. The report takes the information directly from the form. The problem I am having is that when I select to print the report it may print 3,4,5, and sometimes up to 30 copies. I have been over and over the settings and cannot find it. I tried to code it to only print 3 copies and it printed 3 times 3,4,5, or whatever it feels like.

Does this sound familiar to anyone?

Thanks
RichB

spacepro · Jan 21, 2004

I have previously used the following code to print 3 copies only of a particular record. You should be able to adapt the code to your ends.

Code:

 Dim strDocName As String
 Dim numcopies As Integer
Dim strLinkCriteria As String
numcopies = 3
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
strDocName = "Delivery"
strLinkCriteria = "[ID] = Forms![frmhold]![ID]"

DoCmd.OpenReport strDocName, acViewPreview, strLinkCriteria, "ID = [Forms]![frmhold]![ID]"
DoCmd.PrintOut acPrintAll, , , , numcopies
DoCmd.Close acReport, "Delivery"

Basically setting numcopies for the number of copies required and then using the printout command to carry this out.

Hope this Helps

Andy

R6Flyer · Jan 21, 2004

Sounds more like a problem with the record source for the report.

Have you tried running the query to see what results it is giving - I would hazard a guess that you have several linked tables in the query and it is creating duplicate records.

Cheers

Flyer

Multiple Copies of Report Print!

RichB

New member

spacepro

Registered User.

R6Flyer

Yamaha hooligan

Similar threads

Users who are viewing this thread