October 10th, 2013, 12:07 PM
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!
Last edited by r937; October 15th, 2013 at 12:02 PM.
October 15th, 2013, 10:45 AM
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?
October 15th, 2013, 12:02 PM
you, that was
Originally Posted by Marcieface
removed it, i did