Print dialog using OpenReport.... acNormal?

[ARC]

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

[paii, Ron]

"ARC" <PC*****@PCESoft.invalidwrote in message
news:vU*******************@newssvr12.news.prodigy. net...

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.

[Tom van Stiphout]

On Wed, 31 Oct 2007 14:00:59 GMT, "ARC" <PC*****@PCESoft.invalid>
wrote:

You meant to say: in other packages I don't have the convenience of
printing straight to the default printer. And in Access I can still
get the print dialog: just preview the report and have the user choose
File Print. :-)

-Tom.

>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

[ARC]

Well, the user's are a bit funny, they don't want to preview first! :(

Yet getting the print dialog is still a feature they want.

"ARC" <PC*****@PCESoft.invalidwrote in message
news:vU*******************@newssvr12.news.prodigy. net...

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