Updating/changing hyperlinks

[mandaman]

Here's a tip for anyone trying to update or change a series of existing hyperlinks: you can use the >edit>replace feature on the menu to make changes to multiple records, BUT first you need to change the field type to text. Access shows only the display part of the hyperlink in a table when the field type is set as hyperlink, but the actual link info is hidden. If you change the field type to text the hidden link appears, and you can use replace to make the changes you want. Be sure to set the length of the text field to 250 before making the change. When you're done just change the field type back to hyperlink, and you're good to go.

For example, we had dozens of hyperlinks to documents in folders listed by months. When we moved all of the February documents to March, i had to update all of the hyperlinks. I change the hyperlink field type to text, did a replace search on 'February 2006' (any part of the field) and change it to 'March 2006'. The I switched the field type back to hyperlink. I didn't find anything on this procedure after searching the forums, so I thought I'd pass it along.

 

[snowman]

thanks for the tip, thats actually gonna help me out with some links that i need to update!

 

[ralphyehle]

when i tried this (saved as test and then changed to hyperlink and saved) the hyperlink has a http:// in front of the file location. I am trying to hyperlink to pdf files and Excel files in the same folder using "myfile.pdf" as the address. When I manually enter this it works but when I try to do what you suggest I get the above which doesn't work. Any suggestions? Am I doing something incomplete?