Outputting one file per record

C

cooke.christopher

I have a very simple task that I have been struggling to complete and
cannot locate an answer on the web.

I have generated a simple report where each record is displayed in a
format that is somewhat like a resume. Right now the report generates
one or more pages per record, in direct sequence as would be expected.

What I need to do is have Access save each record's pages as an
individual file with a file name generated from the record (lastname,
firstname).

I hope to have these as PDF, I have seen some discussion but do not
really follow. I have Acrobat, so creating a pdf from a rich text
would not be the end of the world, but perhaps laborious.


**Bonus Twist** Once a record is output to a file, this fact is noted
in a table so that the next time the report is run, only new files are
output.

Thanks in advance
CPC
 
Top