469,625 Members | 998 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

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 9363

"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
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.