Re: Print dialog using OpenReport.... acNormal?


"ARC" <PCESoft@xxxxxxxxxxxxxxx> wrote in message
news:vU%Vi.61518$Um6.38875@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello all,

Using the following command, is there any way to get the printer dialog to
open? I most packages, when you click print, it will open the printer
dialog, however Access sends the report without the dialog. I was hoping
there would be another option, other than acNormal, but there doesn't
appear
to be:

DoCmd.OpenReport Forms!frmOpt.Form!RunName.Caption, acViewNormal

Thanks!

Andy


Replacing acViewNormal with acViewPreview will open the report in preview
mode which will allow you to open the print dialog box and print the report.


.

Relevant Pages

  • Re: [SLE] KFTP Grabber Crashes Now after reboot
    ... This is interesting because Pascal builds great packages. ... installing a package? ... It remembers these settings and will not report them ... From the command line as a regular user it crashes. ...
    (SuSE)
  • Re: Saving changes on form before running a report
    ... On the Command button (that you already use to open the report) ... When the code window opens, the cursor will be flashing between 2 ... DoCmd.OpenReport "ReportName", acViewPreview ...
    (microsoft.public.access.forms)
  • Re: Report Error With No Data
    ... The report exports to Excel fine, but when there is no data abends from the ... Is there a way after issuing this command: ... DoCmd.OpenReport Me.cboReportType, acViewPreview, to NOT issue the next ...
    (microsoft.public.access.reports)
  • Print dialog using OpenReport.... acNormal?
    ... Using the following command, is there any way to get the printer dialog to open? ... I most packages, when you click print, it will open the printer dialog, however Access sends the report without the dialog. ... Andy ...
    (comp.databases.ms-access)
  • Re: Command button report selection
    ... My report names are not for ... > change the last argument form acViewPreview to acViewNormal. ... >> I'm trying to create a Form that based on the users combo box selections, ... >> the correct report will run when a command button is selected. ...
    (microsoft.public.access.reports)