ML
asked on
Print and Export to PDF Buttons on Reports
Is there a way to add a couple of buttons on an Access 2016 report for Printing and Export to PDF?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Here's an example of a report form from one of my applications. There are 5 output options. The first is a list style form that acts like a to-do list. The users just pick the next subscriber on the list to open the primary update form. Some of the reports can be exported to excel. those are marked in the Export Available column. Keep in mind that if the criteria for the report is self contained, you do NOT have to preview it first. You can just send it directly to .pdf.
ASKER
Scott, I did change my search to a combo box on my main menu form. Looks so much better! But when I go to add a button to export with the code you provided directly onto the report, I don't see the button after I run the report from the combo box. Does that make sense? If I open the report up manually, I do see the button.
ASKER
Pat, I really like the radio buttons! I'm pretty novice at Access so I'm not sure how to work that up. I do like how all the options are there to see. I believe having them open the report in preview would be best, then give the option to export or print.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.