471,863 Members | 1,215 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,863 software developers and data experts.

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

Oct 31 '07 #1
3 9596

"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.
Oct 31 '07 #2
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
Oct 31 '07 #3
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
Oct 31 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Ian | last post: by
3 posts views Thread by TDIOwa | last post: by
10 posts views Thread by N J | last post: by
NeoPa
reply views Thread by NeoPa | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.