Change the path of a hyperlink field

  • Thread starter Thread starter Maria Joao
  • Start date Start date
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
 
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?
 
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
 
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
 
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...
 
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
 
Back
Top