produce PDF as well as name the filename automatically

[aquinox]

Hi,

I was wondering if anyone might be able to help me here. This is what i would like it to happen. I would like to be able to produce PDF out of Access reports as well as naming the file out of the records automatically.

For example,
When clicking on a button called "Get PDF Reports" on a form, it would automatically convert Access report to PDF Report Format and generate the filename out of an unique field in the table (eg. Student_FName and Student_LName) without user intervention.

This way, there is less human error in giving the files with the wrong name.

Thank you in advance

 

[jrbarnett]

If you search this site, there are threads and FAQs (including faq705-1635) about automating the Adobe PDF writing software from VBA to do what you want.

John