Is there an easy way to export a form with roughly 50,000 entries into PDF files with a specific field as the file name?
Is there an easy way to export a form with roughly 50,000 entries into PDF files with a specific field as the file name?
think you need to clarify - you want to generate 50000 pdf's?
the export part is easy, use the docmd.outputto method - https://docs.microsoft.com/en-us/off...docmd.outputto
As to the rest of it, all depends on what you are actually trying to do
thats called a Report.
the query pulls the data into the report,
use a form and listbox to filter by 'dept' (or other list) then the output would be like:
vFile = "c:\folder\MyReport_" & cboDept & "_" & format(Date,"yymmdd-hhnn") & ".pdf"
DoCmd.OutputTo acOutputReport, "rMyReport", acFormatPDF, vFile