Printing

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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?
 
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
 
Thank you, I while try that! Pixie

Alex Dybenko said:
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
Click to expand...
 
Back
Top