Windows Printer Dialog How to get a value from the Ok button.

[Goondu]

Hi,

I'm not going to use the API as Access Runtime File Menu Print Dialog is controlled by Windows. So, API just don't cut it.

Users will be running Access Runtime to print from Access Print Menu once the Report is viewed mode. Meaning, users click on the Report in view mode than click on the Access Menu Print button and click the "Ok" button to print.

How can I get info or parse the value from the Windows Printer Dialog to the module of the Form or a Standard Module in VBA?

I need this to tell Access to print a second same copy with slight modification to the controls(TextBoxes) if the user wishes to Preview or Print a second copy.

I can't use the API as it will block the Report preview mode. Users need to preview before printing.

 

[LaurieHamlin]

I don't quite understand what you're doing, but maybe this will help. I've created some Access DBs that others use to print letters. I've created forms to show the data in the correct format (with a print button) and identical reports to actually print (without the print button).
Good luck!

 

[Goondu]

No can do.

Selection of printers is still required.

Need the print pre-view before printing 2 sets. The second copy is the same but layout with textboxes hidden.

It's not an issue if the button is on the form. This must be done in Pre-view mode of the Report. This must be an automated process hidden to the user. Just like you use Word or Excel menu which you can print 2 copies at one go.

I need this windows printer dialog to parse info to Access Report. Can't do it with custom API method as it will block user in Pre-view mode. This must be done in Access Menu.