I'm looking for a very simple solution here. I simply want a vba script that I can run over and over again to save the same Access report (that changes as the weeks go by) into the same file over and over again. I need it to be the same name each time and don't want to be prompted that the filename is already there. In my research, it feels like the following should work but it does not. Can anyone provide a simple script that performs this task?
Sub program() DoCmd.OutputTo acOutputReport, "Employee1", acFormatPDF,"C:\Users\desktop\PDFs\Report1.pdf" End Sub
96.7k 11 11 gold badges 79 79 silver badges 137 137 bronze badges
asked Jan 14, 2016 at 20:39
87 1 1 gold badge 1 1 silver badge 5 5 bronze badges
Add a line continuation character (underscore: _ ) to indicate the line following DoCmd.OutputTo should be considered part of the same logical instruction:
DoCmd.OutputTo acOutputReport, "Employee1", _ acFormatPDF,"C:\Users\desktop\PDFs\Report1.pdf" The line continuation character must be preceded by at least one space, and there can be no characters after the line continuation.