How Can I Convert My Report to Tiff Image En Mass?

[TWD]

Hey guys,



I'm pretty much way over my head with this one, but hopefully someone can at least point in the right direction. I have an Access report that I want to convert to a TIFF image. Sounds simple enough. I downloaded a converter virtual printer program and select that as my printer.

But here is the big wrinkle. I need to do this 10,000 times so it needs to an automated process. First, let me explain how the report works.

First, it launches an update query that asks for the SSN number. You enter the number, the query finds the matching record in the main table and updates it to a new table. Then my access report launches and reads in the data from the new table which only has the one record. (a macro launches when you open the access database that deletes all records out of this new table). I need to automate this process:

Retrieve SSN
Generate Report
Print report to TIFF with a unique filename
Retrieve next SSN

I really don't have a clue how to do this. I can't get away with having to do something manually 10,000 times in the process. Can anyone help?

[June7]

I have code that saves reports to PDF. I found that it crashes if I did more than about 5,000 (I had 70,000 to get through - 20 years of data). Review https://www.accessforums.net/import-...ges-25042.html

Instead of OutputTo, I guess you would use Printout method.

Why bother writing record to 'temp' table. Just open report with filter criteria applied.