Use Lebans pdf report writer to Print Individual report pages

[BearPaw]

Dear All,

I have been looking through these groups to see if I could find an
answer to this (apologies if I have overlooked something obvious).

I will explain:

I have a report formatted to fit to one page per record (no. of
records vary according to the query), and I'm looking to print each
individual record of to an indivdual pdf file (Using Lebans
A2000SnapshotToPDFver751), saved in accordance with currently defined
name of the record based upon a combination of the [ID] field, [Date]
field, and [Surname] field.

I have a working knowledgle of vba (I know enough to get myself into
trouble, but not enough to get myself back out!).

I beleive in might be possible by means of saving each of the
individual snapshots, but if anyone could walk me through this (or
another method) I would be very grateful.

Kindest Regards




Marc

p.s. I would just like to echo my thanks Stephen for this excellent
utility.

 

[Tony Toews [MVP]]

I have a report formatted to fit to one page per record (no. of
records vary according to the query), and I'm looking to print each
individual record of to an indivdual pdf file (Using Lebans
A2000SnapshotToPDFver751), saved in accordance with currently defined
name of the record based upon a combination of the [ID] field, [Date]
field, and [Surname] field.

You need to open the report for each record.

For a page on how to print a report for a single record and how to
generate reports to attach to emails see the Emailing reports as
attachments from Microsoft Access page at
http://www.granite.ab.ca/access/email/reportsasattachments.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[BearPaw]

I have a report formatted to fit to one page per record (no. of
records vary according to the query), and I'm looking to print each
individual record of to an indivdual pdf file (Using Lebans
A2000SnapshotToPDFver751), saved in accordance with currently defined
name of the record based upon a combination of the [ID] field, [Date]
field, and [Surname] field.

You need to open the report for each record.

For a page on how to print a report for a single record and how to
generate reports to attach to emails see the Emailing reports as
attachments from Microsoft Access page athttp://www.granite.ab.ca/access/email/reportsasattachments.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm

Tony, thanks for the reply.

I've been trying to work my way through this but I'm not making much
progress. Is it possible to expand what is already there.

I have a report format that fits one page per record.

If the query it is based upon pulls 6 (for the sake of argument)
records, I would like to print each record (i.e. a single page report)
seperately, whilst saving them using a unique filename.

What would the stages be to do this? Would it be possible to provide
some sample code?

Marc

 

[Tony Toews [MVP]]

I've been trying to work my way through this but I'm not making much
progress. Is it possible to expand what is already there.

I have a report format that fits one page per record.

If the query it is based upon pulls 6 (for the sake of argument)
records, I would like to print each record (i.e. a single page report)
seperately, whilst saving them using a unique filename.

Sorry about that. I missed one crucial web page. You need to loop
through the recordset based on that query with the six records
printing the report for each individual record.

Sample Code illustrating looping through a DAO recordset
http://www.granite.ab.ca/access/email/recordsetloop.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm