Print Report Using DoCmd

[cmmd2003]

Can anybody explain why this does not work

Private Sub Report_Open(Cancel As Integer)
DoCmd.PrintOut acPrintAll
End Sub

Im getting the error message

This action cannot be carried out while processing a form or report event.

 

[missinglinq]

What exactly are you trying to do? DoCmd.PrintOut is not used to print reports, it used to print "pages" of a form or datasheet, from within that form or datasheet.


The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[cmmd2003]

Well basically, from a switchboard, i want to print a report without having to open it, go to filed and then click print. Ideally i just want it to open and print on its own.

 

[PHV]

i just want it to open and print
DoCmd.OpenReport "YourReportName", acViewNormal

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cmmd2003]

How do you print

 

[PHV]

Place the cursor inside the OpenReport word in your code and press the F1 key.

 

[cmmd2003]

That doesnt help. From the switchboard, i want to click a button that will open the report, and the report prints automatically.

I tried using the code

DoCmd.PrintOut acPrintAll

In the On open event to no success.

Im getting the error message

This action cannot be carried out while processing a form or report event.

How can i make it work

 

[randy700]

cmmd2003,

Replace your code with the code given to you by PHV. Then, follow his instructions regarding the F1 key.


Randy

 

[cmmd2003]

when i use his code i get the same error.
And f1 attempts to install some form of help that i dont have and it fails.

 

[randy700]

Try this...

DoCmd.OpenReport "YourReportName"

If it doesn't work, post your exact code.


Randy

 

[cmmd2003]

Private Sub Report_Open(Cancel As Integer)
DoCmd.OpenReport "RptItem"
End Sub

 

[ck1999]

PHV code should be placed on the on_click event for the command button on your switchboard.


ck1999

 

[cmmd2003]

how can you reference a particular button

 

[randy700]

In form view, right click on the button.
Select properties.
When the properties box appears, select the events tab. Click in the box next to On Click and select Event Procedure.
Next, click on the elipses (3 dots) button to view and edit the code.


Randy