Report Name (1 Viewer)

Gismo · Feb 15, 2019

Hi All,

Is it possible to have a report name based on a value in a form?
Every time the value changes in the form, the report name should change as I export to PDF and would like to have the report name for each export to be unique

theDBguy · Feb 15, 2019

Hi. I hope you don’t really mean you want to change the name of the report and just the name of the PDF file when you export the report. If you really want to change the name of the report, you could try using DoCmd.Rename.

Gismo · Feb 15, 2019

yes only the PDF file name will do.

How will I use DoCmd.Rename to select the record selected on a form?

theDBguy · Feb 15, 2019

Hi. You don’t need DoCmd.Rename any more. Instead, you can use DoCmd.OutputTo and just specify the filename in the argument.

Gismo · Feb 19, 2019

I is not possible to rename the Output PDF automatically to a value in a specific form which was selected?

theDBguy · Feb 19, 2019

Hmm, not in front of a computer now, but doesn’t the OutputTo method have an argument for the filename? If so, you should be able to specify the name of the PDF file. Can you post your OutputTo code, so we can tell how we can modify it? Thanks.

Gasman · Feb 19, 2019

Gismo said:
I is not possible to rename the Output PDF automatically to a value in a specific form which was selected?

Of course it is

https://docs.microsoft.com/en-us/office/vba/api/access.docmd.outputto

Report Name (1 Viewer)

Gismo

Registered User.

theDBguy

I’m here to help

Gismo

Registered User.

theDBguy

I’m here to help

Gismo

Registered User.

theDBguy

I’m here to help

Gasman

Enthusiastic Amateur

Similar threads

Users who are viewing this thread