Selecting Hyperlinks

[Guest]

I have prepared a form for my users to provide links to certain documents in
hyperlink fields. I would also like to provide them with a button that will
open all of their hyperlinks at once, in one document, in a print preview
format. I have some ideas, however, I can't even figure out any code to open
a specific hyperlink. Also, these hyperlinks may have different names, but
the actual field names are stored in a table and will remain the same. Will
this be a problem?

 

[Guest]

Are you saving your hyperlinks as records?

To open a hyperlink I put the following code in a button click event. Where
"AttDoc" is the name of the field (it is this simple!).

Application.FollowHyperlink AttDoc



Here is a sample database that maybe useful.

http://www.rogersaccesslibrary.com/download3.asp?SampleName=SetHyperlink.mdb