I have a question about exporting Access records. I have used access for years and know how to export a table to a single pdf file, but for numerous reasons I would like to export each record in the table to individual pdf files. From the research I've done already it can apparently be done using VBA but I can't find anywhere that explains it easily.
Sami Shamma
@Reply 2 years ago
Hi Alex
I use a loop to go through the records that I need to print. for each record, I will issue the print then the export to pdf for that record.
you need the print first because out put to pdf does not allow you a "WHERE" close. so put your WHERE in the regular print and it will maintain that for your pdf output.
Sami Shamma
@Reply 2 years ago
use something like this code inside you loop or Recordset:
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access TechHelp.
