Print all hyperlinked documents in a table?

[rsmccli]

Hello. Long time reader, first time poster... Anyway, here is my problem.

We are using Access 2002

I have a subform on our FE where you pick a document name from a combobox, then input a hyperlink address in a text box next to it. These values are stored in a table named tblHyperlinks with the document type as a lookup/number (field name strDocName) and the hyperlink itself (field name hypLink).

Once all of the applicable documents' hyperlinks are inputted, I want to be able to add a command button that will print each hyperlinked document stored in the table (in a certain order). These documents are located all over within the server, not in the same folder, although it may be possible to centralize them, if that would make this process easier. These are mostly MS Word documents.

Is this even possible? I am getting to know the basics of VBA, but after some internet searching I did not find much information on this subject. I have not posted any code because I am kind of looking for a "starting point" here.

Any help would be appreciated greatly.

[rsmccli]

In case someone needs help on this problem:

I did eventually find some ways of doing this, the easiest of which was found on Graham R. Seach's site here:

http://www.pacificdb.com.au/MVP/Code/ExeFile.htm


Thanks