Saving one Record as PDF

pjd71

New member
Local time
Today, 06:11
Joined
May 10, 2016
Messages
3
I created this database a few years ago and have made tweaks to it each year. It is designed for use of many users to forecast budgets.
I have attached the database and to get it to open to view, please use the shift button when opening.

Within the form "FCP Requests", I attempted to use a macro with the intention to save the current opened document as a PDF. Basically, pointing to the report "FCP Request Print" This database is used on a share drive by many users. When the button "Save Copy as PDF to Your Computer" is clicked, it saves every request to one file. The end user only needs the current one they are viewing.

Created another button on the form in an attempt to do the save as PDF function, named for now, "Command110". Have tried and searched many forums for a VBA code to save, but again no luck. :banghead:

Could someone help me with this?

Patrick Dostal
Retired Marine
 

Attachments

Hi Patrick,

Couple of ways to handle this.
1) If the report you want to save is only used for this action, set the report filter so [ID]= Forms.[FCP Requests].[ID] and the FIlter On Load to TRUE. If the report is used elsewhere, create a copy just for this action.

2) Use a query to return just the current recordset and use that query as the recordsource for the report.
 
Hi Patrick,

Couple of ways to handle this.
1) If the report you want to save is only used for this action, set the report filter so [ID]= Forms.[FCP Requests].[ID] and the FIlter On Load to TRUE. If the report is used elsewhere, create a copy just for this action.

2) Use a query to return just the current recordset and use that query as the recordsource for the report.


Thanks, I used option 1. Perfect! It was the only thing that report is used for. Perfect and easy.
 

Users who are viewing this thread

Back
Top Bottom