Results 1 to 2 of 2
  1. #1
    HoopaWildlife is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    1

    Print linked pdfs with their associated reports

    We have an Access form that we use to enter data. There are hundreds of records with their own seperate linked pdf (field notes). In each record there is a box that we "insert object" into (our scanned field notes-a pdf file)- a linked document in each record that is associated with that record.



    At the end of each year we print out reports from each record. We then print out the pdf documents (field notes) seperately and then match them up and file them together.

    This seems crazy and barbaric to me because the pdf is already associated to the records!

    Is there a way to print out the reports so that each associated pdf prints out with each report? (so that at the printer I see report1, pdf1, report2, pdf2, etc...?

    This way I can just grab the papers from the printer and staple each report with its associated pdf... <I mean this is 2011 right? It seems like there should be a way to do it. They are already associated!>

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Google: vba Shell print pdf

    Here is one
    http://www.ehow.com/how_6199098_use-...-pdf-file.html

    It shows a procedure that receives a file name as an argument. How you retrieve that file name from your database is another issue.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Print Linked Images in a Report
    By bosve73 in forum Reports
    Replies: 4
    Last Post: 02-02-2012, 11:12 AM
  2. Print linked pdfs within an Access Report II
    By cjwagner in forum Reports
    Replies: 3
    Last Post: 05-30-2011, 04:25 PM
  3. Print linked pdfs within an Access Report
    By alpruett in forum Reports
    Replies: 6
    Last Post: 05-20-2011, 05:25 AM
  4. Print different Reports at once
    By Brian62 in forum Reports
    Replies: 5
    Last Post: 01-21-2011, 11:19 AM
  5. Option to Print Sub-reports
    By Hotwheels59 in forum Reports
    Replies: 0
    Last Post: 06-21-2010, 03:29 PM

Tags for this Thread

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