By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,807 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,807 IT Pros & Developers. It's quick & easy.

Print all hyperlinked documents in a table?

rsmccli
P: 52
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.
Jan 30 '08 #1
Share this Question
Share on Google+
1 Reply


rsmccli
P: 52
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
Jan 31 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.