Change the path of a hyperlink field

[Maria Joao]

I need to change the path of an hyperlinf field that opens a PDF File.
I need to change the path os it and send it to look on the CDROM Drive, but
I dont´t want to have to type everything again.

Is tehe a way to perform this?

Thanks

Maria Joao Bazenga

 

[Scott McDaniel]

I'm not sure what you mean by "I don't want to have to type everything
again".

Can you post the code or link for the hyperlink?

 

[Maria Joao]

I have a field that is hyperlink and I an change it manualy to the new path.
The only problem is that there are around 4500 record, and I have to type
all of them.
I want to change it with code, in an automatic way.

Thanks

Maria Joao

 

[=?iso-8859-1?Q?J=F6rg_Ackermann?=]

I have a field that is hyperlink and I an change it manualy to the
new path. The only problem is that there are around 4500 record, and
I have to type all of them.
I want to change it with code, in an automatic way.

What's about
Replace([Hyperlinkfield];"YourOldPath";"YourNewPath")
in a Update-Query?

UPDATE Tabelle1
SET Hyperlinkfield =
Replace([Hyperlinkfield],"d:\testfiles","d:\companyfiles");


Acki

 

[Maria Joao]

But I have a new link for each record, every one is diferent.

I want to change: c:\testfiles\a.pdf and c:\testfiles\b.pdf and
c:\testfiles\c.pdf ......

to d:\folder1\a.pdf and d:\folder1\b.pdf and
d:\folder1\c.pdf ........

Thanks

Maria Joao Bazenga

I have a field that is hyperlink and I an change it manualy to the
new path. The only problem is that there are around 4500 record, and
I have to type all of them.
I want to change it with code, in an automatic way.

What's about
Replace([Hyperlinkfield];"YourOldPath";"YourNewPath")
in a Update-Query?

UPDATE Tabelle1
SET Hyperlinkfield =
Replace([Hyperlinkfield],"d:\testfiles","d:\companyfiles");


Acki

 

[=?iso-8859-1?Q?J=F6rg_Ackermann?=]

But I have a new link for each record, every one is diferent.

I want to change: c:\testfiles\a.pdf and c:\testfiles\b.pdf and
c:\testfiles\c.pdf ......

to d:\folder1\a.pdf and d:\folder1\b.pdf
and d:\folder1\c.pdf ........

UPDATE YourTable
SET Hyperlinkfield =
Replace([Hyperlinkfield],"c:\testfiles\","d:\folder1\");

Replace table- and fieldname with yours.

HTH