Printing

[Guest]

I want to use the built in menu functions to print a report out. I want it to
ask if they want to print the report out or not when they click it to close.
I want this option so I can pick the printer I want use. since this will be
used by several different plants. I have this coded in, but it will not let
me finish the print cycle.
Dim strResponse As String
strResponse = MsgBox("Do you wish to print this report?", vbYesNo, "Print
Report")
If strResponse = vbYes Then
DoCmd.RunCommand acCmdPrint
End If
It will give me a message "This actiuon can't be carried out while
processing a form or report event."
THank you for any help in this matter, and any sugestions you may have to
make this work.
Pixie

 

[Alex Dybenko]

Hi,
regarding change printer - you can look here:
http://www.mvps.org/access/reports/rpt0009.htm

BTW - not sure it is a good idea to ask user if he wants to print a report
each time he close it...

 

[Guest]

THank you.
Is there a way to put a button on a report and code it to print when pushed,
but not show up in the hard copy?

 

[Alex Dybenko]

hi,
best approach it to create a toolbar, add a print button there, and attach
this toolbar to report using Toolbar property
so user can preview report and the press button on toolbar in order to print

also you can use built-in toolbar, for exampe look at screenshot from here:
http://www.pointltd.com/Downloads/Details.asp?dlID=45
you see that report is in preview mode and there is a button to print it on
the toolbar

 

[Guest]

Thank you, I while try that! Pixie

hi,
best approach it to create a toolbar, add a print button there, and attach
this toolbar to report using Toolbar property
so user can preview report and the press button on toolbar in order to print

also you can use built-in toolbar, for exampe look at screenshot from here:
http://www.pointltd.com/Downloads/Details.asp?dlID=45
you see that report is in preview mode and there is a button to print it on
the toolbar