Hyperlink Field click does not work in a Linked Table

[Sonu]

Hello All,



I have a table having a column with Hyperlink data type. There were certain entries/files location into this column which were not opening/working while clicked. Hence, I updated those entries with the following: [column] & "#" & [column]. After this update, I was able to click and get the desired file open.


I have a front-end database where the above table has been imported as a Linked Table. But, all those entries which I had fixed (in the main table) does not seem to be work in this linked table. I can open the files in the main table but if I click on the same file in a linked table, it does not work and gives an error - Cannot open the specified file.


I have refreshed the linked table and also tried deleting and importing as a fresh, but still no help.

In the error messages, I also noticed a difference - One error shows the document/file name as it is and another error replaces the space in the file name with a string '%20'. See attached.


Thank You,

[June7]

A hyperlink field value has 3 parts separated by #. http://allenbrowne.com/casu-09.html

Don't know if the second # to define the third part will make a difference.

It is odd that failed links show difference in display of space.

I don't use hyperlink field type because of its testiness. I would use a normal text field and intrinsic FollowHyperlink function or construct hyperlink with concatenation expression in query or textbox. Then make sure textbox IsHyperlink property is set to Yes.

Another link to review http://allenbrowne.com/func-GoHyperlink.html

[Sonu]

Thank you for the inputs. I will probably try another way to handle this.

[orange]

I see this thread is marked SOLVED, but you have not provided any details nor confirmation of the solution. Since this forum supports a broad community, current and future, please provide some info related to your solution. It may help someone.

It appears that you have some combination of pain text and encoded HTML ( URL encode/decode).

Good luck with your project.