Senin, 08 November 2021

Re: [MSAccessProfessionals] Can I custom name report based on field on form

hi Frank,

you can use the OutputTo statement specifying the report, where clause  if desired, PDF, and the name of the file

once it is a file, you can do this to open it:

Application.FollowHyperlink sPathFile

kind regards,
crystal


On 11/7/2021 6:18 PM, Frank C. D'Amato - KB2MXV wrote:
I have a report named ROC.  When I view the report and print to PDF, it defaults the naming to ROC.pdf

Is there a way for me to save the report based on field of my open form?

Let's say I want to use 3 fields values on my form;
company
model
serial

I would like to name the PDF "ROC - [company] - [model] - [serial]

Is this possible?
--


Thanks
Frank D'Amato

Tidak ada komentar:

Posting Komentar