Report file name change help

[EBee]

I am printing the Access reports to a pdf printer and wanted to change the default report file name that appears when the user is prompted to save the pdf. Currently, the user must append a date and time to the file. I would like to automate this process so the user don't have to type any date/time after the file name.

For some reason the doCmd.Rename does not work because the report file name that shows is the control data source (i.e table, query. .etc). How can this be accomplished without changing the control data source.

Thank you,
ebee

 

[KenReay]

Hi

Does this not depend on the PDF writer software?

I have done something similar and the name of the PDF is set by setting a registry value applicable to the PDF driver, (this can be done in VBA) suggest you refer to documentation for the pdf driver first

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[EBee]

yes and no. In my purpose, no. Since I need to change the default name that appears when you are about to save it to a location on a drive. I have a virtual pdf printer that is setup to manually enter name and I would like to have the default name changed.