Create a PDF from a report without prompts - Access 2003
Posted on 2013-10-23
I am trying to create a PDF from an Access report, but it is part of a loop, so I do not want the PDF writer to open and nor do I want to be prompted for a file name. The loop runs a report, with a counter, so the file it creates will be for example, "Invoice 1.pdf", then "Invoice2.pdf, etc. I have seen various solutions here, but they seem to not do quite what I want.