Code:
DoCmd.OutputTo acOutputReport, "DateExport2009", acFormatPDF, "C:\Dropbox\Database\Exported Files\Master Data - 2009.pdf", False, , , acExportQualityPrint
DoCmd.OutputTo acOutputReport, "DateExport2010", acFormatPDF, "C:\Dropbox\Database\Exported Files\Master Data - 2010.pdf", False, , , acExportQualityPrint
DoCmd.OutputTo acOutputReport, "DateExport2011", acFormatPDF, "C:\Dropbox\Database\Exported Files\Master Data - 2011.pdf", False, , , acExportQualityPrint
DoCmd.OutputTo acOutputReport, "DateExport2012", acFormatPDF, "C:\Dropbox\Database\Exported Files\Master Data - 2012.pdf", False, , , acExportQualityPrint
DoCmd.OutputTo acOutputReport, "DateExport2013", acFormatPDF, "C:\Dropbox\Database\Exported Files\Master Data - 2013.pdf", False, , , acExportQualityPrint
DoCmd.OutputTo acOutputReport, "DateExport2014", acFormatPDF, "C:\Dropbox\Database\Exported Files\Master Data - 2014.pdf", False, , , acExportQualityPrint
DoCmd.OutputTo acOutputReport, "DateExport2015", acFormatPDF, "C:\Dropbox\Database\Exported Files\Master Data - 2015.pdf", False, , , acExportQualityPrint
DoCmd.OutputTo acOutputReport, "DateExport2016", acFormatPDF, "C:\Dropbox\Database\Exported Files\Master Data - 2016.pdf", False, , , acExportQualityPrint
You will notice it is exporting a report...the ONLY difference between those reports are the dates on them. (ie. Only records from 2016) Would it be easier to have ONE report and have some VBA run dates in 2009, output a report, then run a report for 2010, then output that report? Otherwise Every year I am making a new report with only the dates changing, then adding that new line of code to the Exit button on the DB.