Hello

I regularly read posts here but I seldomly post my own topics given I often find what I am looking for in this forum. But this time I'm stumped.

What I would like to do is to create a pdf version of a report and have Access automatically save it in a specific directory.

I found some code in this thread that doesn't quite work for me. The final post includes code that brings up the 'Save As' window. I can get this to work but the user is then prompted with a 'Save' window. Is it possible to modify this code such that it automatically save the report as a pdf?

As an alternative, I tried the code in the 2nd to last post by geekgirlau. After a very small amount of tweaking to suit my report names etc, the routine goes through the motions, the directory is created, I can see the report in preview mode, I get a MsgBox stating the report has been saved but there is no report. (I have Adbode PDF writer installed) A search of the hard drive doesn't reveal the report that was supposedly saved so I guess something isn't quite right. Has anyone else tried the code posted by geekgirlau? Is there an obvious issue that I am missing? (Late edit : there is no print or output command for a start....so that goes some way to explaining why there is no output)

Or does anyone have alternative methods of automatically saving pdf versions of reports?

I am happy to post the modified code if required.

TIA, Andrew