Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2012
    Posts
    23

    Create a report which prints different pdfs for different headings

    Dear all,



    I build an access report which outlines employees of different division (each division on a new page). Fact is that I have to sent the overview to each division. So now I have to print the report (with pdf printer) an then "cut it into pieces".

    Does anybody know a way in which i create some kind of marco that I can create 10 pdf reports of divisions in stead of one pdf with all of them in it.

    Dear regards,
    Marc

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    no, but there's a way to cycle through divisions and print a report for each one of those divisions individually.

    what I usually do is put a unbound field (let's call it fldDivision on a form then put have a button that does something like:

    Code:
    dim db as database
    dim rst as recordset
    
    set db = currentdb
    set rst = "SELECT DIVISION FROM tblTest"
    do while rst.eof <> true
         fldDivision = rst.fields("Division")
         'Export your report to a pdf here
         rst.movenext
    loop
    rst.close
    set db = nothing
    what this does is cycle through all your divisions and populates a field on a form, then the query that drives your report you'd have a criteria in your DIVISION of [forms]![formname]![fldDivision] instead of including all divisions.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 12-07-2012, 01:57 PM
  2. Replies: 3
    Last Post: 10-17-2011, 02:38 PM
  3. Print linked pdfs within an Access Report II
    By cjwagner in forum Reports
    Replies: 3
    Last Post: 05-30-2011, 04:25 PM
  4. Print linked pdfs within an Access Report
    By alpruett in forum Reports
    Replies: 6
    Last Post: 05-20-2011, 05:25 AM
  5. Create PDFs from a report
    By twosides in forum Programming
    Replies: 42
    Last Post: 03-04-2010, 06:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums