How do you use the Print Dialog Box with a Report?
I do not want to put the code in the report itself.
I added a Common Dialog Box, and it works, except if the user hits cancel, it then prints anyway. I have about 8 good Access Books but they do not discuss the Print Dialog Box except in passing.
The Code I am using works, except for Cancel.
cdlPrint.ShowPrinter
DoCmd.OpenReport stDocName, acNormal
I tried to use RunCommand acCmdPrint, but it printed the screen like I hit File | Print.
I appreciate anyone's help and time.
Thanks,
Chris.
I do not want to put the code in the report itself.
I added a Common Dialog Box, and it works, except if the user hits cancel, it then prints anyway. I have about 8 good Access Books but they do not discuss the Print Dialog Box except in passing.
The Code I am using works, except for Cancel.
cdlPrint.ShowPrinter
DoCmd.OpenReport stDocName, acNormal
I tried to use RunCommand acCmdPrint, but it printed the screen like I hit File | Print.
I appreciate anyone's help and time.
Thanks,
Chris.
