Changing Hyperlink In Table Using Search And Replace 3

[mdav2]

is it possible to change the value of a hyperlink field using search and replace in a table in Access. If you use search and replace it will only change the text description of the hyperlink not the underlying value which is hidden from view.

Is it possible to change the text description then run a routine to then make the hyperlink match the value of the text description. Or is it possible to change the underlying hyperlinks (although the text description would then be wrong and would need to be changed)?

Mark Davies
Warwickshire County Council

 

[Remou]

I think an update query would be easier:
[tt]UPDATE tblTable SET tblTable.AHyperlink = Replace([AHyperlink],"rain","snow");[/tt]

 

[PHV]

Have a look at the Application.HyperlinkPart method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mdav2]

Thanks, I got the replace statement to work after a spelling mistake was removed.

The application.hyperlinkpart method could come in hand if needing to manipulate these through code.

Many thanks for the posts

Mark Davies
Warwickshire County Council