To collate same pages while printing

[aman]

Hi Guys

It may be a simple solution of my problem but its driving me mad.
I am writing the following line to print a report:

DoCmd.OpenReport stDocName1, acViewNormal, , mysCriteria, acDialog, topLabelOnReport

but as I want to print two copies of each page so I changed my code into the following:

DoCmd.OpenReport stDocName1, acViewNormal, , mysCriteria, acDialog, topLabelOnReport
DoCmd.OpenReport stDocName1, acViewNormal, , mysCriteria, acDialog, topLabelOnReport

It will now print two copies but doesn't collate same pages while printing. e.g if there are 4 pages so it will be printed out in the following order:

page1,page2,page3,page4,page1,page2,page3,page4

But I want it to print in the following format:

page1,page1,page2,page2,page3,page3,page4,page4... ..

Can anyone please tell me hows it possible.

Thanks
Aman

 

[aman]

Can anyone please figure out my problem? Its been a long time since I am searching the solution of my problem.

Thanks
Aman

 

[Scooterbug]

Have you tried this suggestion?

http://www.access-programmers.co.uk/forums/showpost.php?p=877928&postcount=26

 

[aman]

Hi Scooterburg

I tried a lot of different ways but really no use. As you said I tried the following code as well but it starts printing the form and not the report.

DoCmd.SelectObject acReport, stDocName1, True
    
DoCmd.PrintOut acPages, , , , 2, True

I hope anyone can help me in this.

Thanks
Aman

 

[Scooterbug]

Honestly, I dont know what to tell you. The problem is easily solved by setting the Collate option for the printer properties itself. I know you would like to have it so that the users dont have to do anything but hit the print button....but sometimes, the user has to be responsible for stuff.

Open the report up in preview mode..and instruct the users to print via the File --> Print and select the Collate option they want. That is what I would do instead of pulling out my hair trying to solve the issue.

 

[Rich]

Try Preview first and then use the print out method

 

[aman]

Hi Rich

If I preview the report first and then use printout command then it prints the form twice where the print button is clicked and doesn't print the report. I tried the following method:

DoCmd.OpenReport stDocName2, acViewNormal, , mysCriteria, acDialog, topLabelOnReport
 DoCmd.PrintOut acPages, , , , 2, True

I hope anyone can help me to solve my problem. Its almost a month I am trying to figure it out but no use.

Regards
Aman

 

[DCrake]

Aman

I am closing this thread. You have been told several time not make duplicate threads or open new threads with an existing issue. As far as I am aware you were sent a working solution, and as such I cannot understand why you are persuing this issue.

David