Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


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

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

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


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.

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

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!

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

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close