Hyperlinks in access

[Lifeseeker]

Hello,

If a field contains multiple files that need to be hyperlinked in a column, do I need to separate those files into different columns?

In other words, only one file per hyperlink per cell in Access?

now I have three files stored in one column, but they all have different hyperlinks. When a link is created, all three files go to that URL, but this is not wanted.

Comments/thoughts much appreciated.

 

[ted.martin]

It would be better to have one field per hyperlink as I am not aware that you can join together hyperlinks. In any respect, if you could you would need to separate them to get them to hyperlink.

If you were then to produce a new table with (say) 3 hyperlinks displayed as 3 records, then all you would need is a Make Table for the first record and then 2 append tables for the other two.

Then open this new table and there you have it, one column, 3 records each with a separate hyperlink.

Hope this is what you want.

 

[Lifeseeker]

Two questions:

1) would this require me to know the maximum number of files that need to be hyperlinked? Right now, I believe some records have 5 files each that need to be hyperlinked. So I would need to append 4 tables?

2) with this Make Table method, are you essentilaly talking about a one to many relationship between the main table that houses all records and the hyperlink tables? Or to have some sort of a subform that displays all the hyperlinked files associated with each record?

If this is the case, then there might be a problem because....although each record has at least one hyperlink files, a particular hyperlink file can belong to multiple records. At the end of the day, users would want to click on hyperlinks that are associated with each record one at a time

 

[Simon_MT]

You could try having multiple:

Application.FollowHyperlink WebLink, , True

The web link being the URL, suck it and see!

Simon