Change name of multiple hyperlinks at once

[d-mcc56]

Hello everyone,

I have a table with 2 fields. One field is hundreds of hyperlink paths to folders on my computer. These hyperlinks all have their "Texts to Display:" the same as the path to the folder. In my second field I have the desired "Texts to Display:" for Field 1.

As far as I know you can only edit the "Texts to Display:" of hyperlinks 1 by 1. I was wondering if there is a way for me to replace all the display texts with the text located in field 2 all at once? OR if I can add the hyperlink path from field 1 to all the display texts in field 2.

I figured the best way to do this would be in VBA but unfortunately I am VBA challenged so any help would be great

Thanks all

 

[llkhoutx]

Why not use an update query?

 

[d-mcc56]

I'm pretty new to access, I didn't know that existed. I'll give that a Googlin', thanks.

 

[d-mcc56]

I tried an update query and I set Field1 to be updated to Field2 and when I do that it changes the name like I desire but then it also removes the address path and leaves me with a blue underlined name with no path. Any help??

 

[llkhoutx]

Duh! You have to add the path too.

 

[d-mcc56]

I dont know how I would set that up in the "Update to" section :S

 

[llkhoutx]

PathString & "\" & Name

 

[d-mcc56]

Sorry I feel bothersome but every hyperlink has a different PathString. I don't know what to type for each record to retain its respective path.

 

[llkhoutx]

You're updating a column in a table. You have to now the full contents of the column. if you know the path or paths, you can concantenate them with a file name. This is very, very basic.

 

[d-mcc56]

Thank you for clarifying just how little I know about access, very helpful and motivating.