How to PDF a report many times automatically record by record

[Mysterydave]

Hi,

I have a database where I have to produce lots of reports on a weekly basis. There are only 2 report types at the moment (probably 5 types in the future). I have created a table called "report_criteri a" and I have the fields ("PK","Repor t Type", "Report_Name"," Criteria"). I created a form using this table and I have a command button to open the correct report using "Report_Typ e" field and the "Criteria" field which stores the SQL. I do this using OpenArgs.

What I want is a method of doing this for all of the records in my table and automatically creating a named pdf for each using "Report_Nam e" in a specific file (ideally a new file using todays date i.e "2010 01 25").

I'm no expert and am still getting to grips with using VB. Any help would be greatly appreciated!

[NeoPa]

I don't do PDF printing in an automated way myself, but if you have the facility to create a PDF from a report, then all you need to know is that creating separate files involves running separate reports for each record. To report on a single record the WhereCriteria parameter of the DoCmd.OpenRepor t call must be set to allow only that single required record. Loop around for all your records and you should have a solution.