Create macro save report as PDF

[bishop]

Hi,

I want to be able to have a report automatically generate at the beginning of each month and save it as a PDF file and have that report saved to my access database.

Any help is appreciated.

[June7]

Only way I know how to do this is to run code when the project opens. This can be an autoexec macro or VBA behind a form that is set as default to open. The procedure would check date and if is the 1st, continue. There is lots of coding info out there on the actions you want accomplished. Attempt code and when you have issues, post specific question.

I do suggest that saving the PDF in the database is ill-advised. Results in file bloat. Instead save PDF file path.

[bishop]

Could you please walk me through on how to set this up?

Thank you

[June7]

No, too involved. You need to do some research.