Change the path of a hyperlink field

M

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
 
S

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?
 
M

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
 
J

Jörg Ackermann

Maria said:
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.
Click to expand...

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

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


Acki
 
M

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




Jörg Ackermann said:
Maria said:
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.
Click to expand...

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

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


Acki
Click to expand...
 
J

Jörg Ackermann

Maria said:
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 ........
Click to expand...


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

Replace table- and fieldname with yours.

HTH
 
Top