I have a database that is currently generating a pdf file based on query criteria, the query is set to only generate records with transactions. This pdf file is automatically set to be stored in another folder. See what I think is the code for this procedure.
I need to prevent a report from being generated and stored in this folder if it is contains no transactions.
DoCmd.OutputTo acOutputReport, "Peter Marathon - PF Plan",
"*.pdf", Me.[txtExportFilename] & " Peter Marathon - PF Plan
Any help is appreciated.