#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    9
    Rep Power
    0

    Print Hyperlinked Documents from Access?


    It is possible to automate the printing of hyperlinked PDF files from Access 2010?

    I have a query (but I don't believe it's running properly as I'm getting no results):

    SELECT DISTINCT Product.MSDS
    FROM Product INNER JOIN tblStoreProducts ON Product.[ProductKey] = tblStoreProducts.[ProductKey]
    WHERE (((tblStoreProducts.MaxUnits)<>0) AND ((Product.HazardKey)<>79));


    I'm not sure why it's not returning results, as I have the hyperlinks to the PDFs in the database. If someone can help me with this, I'd appreciate it.

    Once this works, is it possible to send the Print command to automate the printing of all of the documents? I'm trying to automate this process for the company I've been contracted to, but I don't even know if this is possible from within Access 2010.

    Thank you for your help and input!

    Marcie Fessler
    Last edited by r937; October 15th, 2013 at 12:02 PM.
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    9
    Rep Power
    0

    Did I do something wrong?


    Can someone explain the reason for the Thumbs Down on this? I'm not sure if I did something wrong?

    Marcie
  4. #3
  5. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    Originally Posted by Marcieface
    Can someone explain the reason for the Thumbs Down on this?
    you, that was

    removed it, i did
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo