My situtation:
I'm not very good at Access. I've created a report (R_SalesHist) listing 1000 customers sales history. Each customer's sales history fits nicely on a single page. When I run R_SalesHist I need it to produce a PDF file for each customer number at the page break. The PDF file names need to be uniquely named as "CustomerNumber".PDF. So I'll have 1000 PDF files when the process runs. I do have a small budget and could buy a package if there is one that keeps me from having to write code.
My questions:
I have downloaded CUTEPDF to have the print to PDF ability. I know you can run a query to pick each customer number then run the report for that customer number - but not how. Can some one show me an example macro/code to do this please?
CUTEPDF uses the report name R_SalesHist as the file name for the PDF it creates. If I run the report multiple times how do I get the PDF files uniquely named as "CustomerNumber".PDF?