By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,326 Members | 1,932 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,326 IT Pros & Developers. It's quick & easy.

Report printing

P: n/a
Can anyone help me!

I'm trying to create an automatic printing process involving an Access
database, at present I have 9 different reports set out, what I want
is each report to print out using a PDF printer. I'm currently using
eDoc PDF printer which will automatically name each printout and place
it in a folder, my problem is that every time I print a report using a
macro it prints all the records in that report so I end up with one
PDF file with all the records in, is there anyway for Access to print
each individual record in a report separately so that I get a PDF for
each record?

Any help would be great.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 4 Jun 2004 08:07:52 -0700, ma*******@airvent.co.uk (Marc) wrote:

No. Just like you can't print each page to a different printer.

But you can run a report about a single record, using code similar to:
for i = 1 to 10
docmd.openreport "myreport",,,"MyPrimaryKeyValue=" & i
next i

-Tom.

Can anyone help me!

I'm trying to create an automatic printing process involving an Access
database, at present I have 9 different reports set out, what I want
is each report to print out using a PDF printer. I'm currently using
eDoc PDF printer which will automatically name each printout and place
it in a folder, my problem is that every time I print a report using a
macro it prints all the records in that report so I end up with one
PDF file with all the records in, is there anyway for Access to print
each individual record in a report separately so that I get a PDF for
each record?

Any help would be great.


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.