Hyperlinks in records

[Richard]

Hi

I need to do a find and replace on a hyperlink field. There are 70 records
with a number in the HSE field (hyperlink field). But it is the path of the
hyperlink I need to change, the path you see when you right click on the
hyperlink field and do Edit hyperlink.

The field only displays the number ie 01801424.

This is what it looks like when I do right click and Edit hyperlink:-

Text to display: 01801424

Type the file or Web page name:

...\..\Sites\The Walk Depot\Health & Safety\Accident
Reports\0022477-01801424.pdf

I need to change the above virtual path to the following ie add Support
Services.

...\..\Support Services\Sites\The Walk Depot\Health & Safety\Accident
Reports\0022477-01801424.pdf

Is there a way I can do this all in one go, rather than going into every
record and doing right click and Edit hyperlink?

Many thanks for any advice given.

I am using Windows XP and Access 2000.

 

[Richard]

I have solved my own problem.

I changed the hyperlink field in the table to be a text field in design mode.

I can then open the table and use find and replace as the whole hyperlink is
displayed.

Then I go back into design mode in the table and change the field from being
a text field into a hyperlink field.