Button to print two reports 1

[McFestoe]

I have the following behind a button that brings the report up on the screen.


Dim strWhere As String
strWhere = "[ID]=" & Me.ID
DoCmd.OpenReport "Keyholder to Cust", acViewPreview, , strWhere
End Sub

iam i right in thinking if i change the DoCmd to

DoCmd.Openreport "Report 1", Report 2", acprint,,strWhere

That this would run two reports and send them straight to the printer?

Thanks in advance

 

[scriverb]

No but this would do that:

DoCmd.Openreport "Report 1", acprint,,strWhere
DoCmd.Openreport "Report 2", acprint,,strWhere

Post back if you have any questions.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[McFestoe]

Scriverb

Thanks for the help once again........

 

[McFestoe]

Scriverb,

Sorry to post back, i have been trying to sort this out on my own and dont understand the message iam getting from the following code.

Private Sub Command374_Click()

Dim strWhere As String
strWhere = "[ID]=" & Me.ID
DoCmd.OpenReport "Paperwork Checklist", acPrint, , strWhere
DoCmd.OpenReport "Paperwork Handover", acPrint, , strWhere


End Sub

WIth the above i get Complie error: Variable not defined (highlighted acPrint)

With the following it works and brings the reports on screen then we select print, i wanted to automate this process, also is there a way to ask the user either to view on screen or print (just a idea that has come to me)

Private Sub Command374_Click()

Dim strWhere As String
strWhere = "[ID]=" & Me.ID
DoCmd.OpenReport "Paperwork Checklist", acViewPreview, , strWhere
DoCmd.OpenReport "Paperwork Handover", acViewPreview, , strWhere


End Sub

Thanks again

Richard

 

[scriverb]

You are using the wrong argument setting. Use the following:

From ACCESS Help:

acViewNormal prints the report immediately. If you leave this argument blank, the default constant (acViewNormal) is assumed.

Good luck.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[McFestoe]

Scriver,

Sorry to be a pain....

Could you explain what acPrint does i assumed it was for printing and in other parts of the db i have used acPrint and it works fine,

If i try something will you have a look at it just got a idea?

Richard

 

[scriverb]

I have always used acViewNormal or left the argument blank so that the default acViewNormal was used. acPrint may be from another function but not this one that I know of.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]