Macro - Print Setup Screen not just Print Auto

[kermitforney]

Is there a way to set up a macro topop up the print setup screen (w/Quality, Copies, Collate, etc.) instead of just printing automatically without popping up the setup screen for each print??

 

[PaulF]

If you want to do this with a Macro you can do it with 3 steps (1 extra just to ensure the report is visible behind the Print Dialog Box).

1.OpenReport - Your Report Name
2.RepaintObject - Object Type is Report, and Object Name is your Report Name
3.RunCommand - Enter Print as the command

However, this means that you'll have to have a Macro for Each Report you want to do this with, and the Print Dialog Box will open every time you run the report via this Macro.

However, if you want to capture this data only once and use it everytime you run the report, then you'd have to do it in code. Create a form to capture the Report name and all of the values and then store this in a table. Then you can open the table and capture the values you need and add them as parameters to the PrintOut action for DoCmd.
DoCmd.PrintOut [PrintRange],[Page From],[Page To], [Print Quality], [Copies],[CollateCopies]




PaulF