Saving one Record as PDF

[pjd71]

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

 

[Isskint]

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.

 

[arnelgp]

test if this is what you want.

 

[pjd71]

test if this is what you want.

Unfortunately, it saves a blank report. Something else you know what to do?

 

[pjd71]

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.