Print all hyperlinks

[CycleC]

I'm so new to writing codes, this is probably simple but i can't figure it out.....

Here is my problem, I have a database that has a hyperlink field called "test reports" and an item field. Every 'item' has a 'Test report' Associated with it. The hyperlink in the 'Test report' field is linked to a .pdf copy of the test report.

When i send a shipment of items i have to send test reports with the items, sometimes hundreds of items. Right now i have a form set up with all the items I'm shipping on a certain invoice. Right now i click on each hyperlink in the "test report" field and open up each test report and print it out. I would like to put a button on my form that prints all 'test reports' on that form.

Basically i need a macro or a code that will print all the hyperlink content on a form or even a query.

Any suggestions ???? Thanks in advance ! CycleC

 

[ezfriend]

You should create a field in the database to hold the hyperlink (file path + filename) data. Using a button, you can just quickly loop through all records using that field and print the PDF.