How to save MS ACCESS reports as PDF?

[taranggoyal]

Hi,

I am creating around 200 reports in MS ACCESS and would want that each of these reports get saved as PDF in a specific location - with each report having a specific name - automatically!

As of now, I have to manually save each of these reports into a particular location and manually enter filename for each of them.

Is there a way such that the file names are automatically taken from an excel sheet or ACCESS table and these reports are saved automatically in a particular location.

Please help!! any guidance is appreciated.

Thanks,
Tarang

[mandanarchi]

Similar question but emailing reports as pdf can be seen here

Click a button and it auto saves report with a name you specify to a folder you specify as PDF. It then attaches it to an email to be sent to someone.

If you don't want to email it anywhere, ignore the middle of the three codes and knock off the "sbSendreturnfo rm fileName" from the last code.

I've put instructions with the codes so it should be fairly easy to mod =)

[WinoLa]

Hi,

I wanna save MS access report to PDF file. I tried your code. I copy the 1st part of ur code to a new module and save it. I ignore the 2nd part because i do not want to email the PDF file.

For the 3rd part, i copy & paste it to a onClick command button. I did the following changes from ur coding:-

Report = "E-Invoice Report"
fileName = "C:\payroll \PDF Files" & Date & ".pdf"

I support the "Report" is the report i want to save as PDF file and
"fileName" is where i want to save the file in.

When I try to run it, i get the following error:-

Compile error:
Ambiguous name detected: ConvertReportTo PDF

I'm running in Access 2003.

Any idea how can i rectify it?

Thnks a million in advance.