Change name of multiple hyperlinks at once

d-mcc56

Registered User.
Local time
Yesterday, 17:02
Joined
Nov 6, 2014
Messages
14
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
 
I'm pretty new to access, I didn't know that existed. I'll give that a Googlin', thanks.
 
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??
 
I dont know how I would set that up in the "Update to" section :S
 
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.
 
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.
 
Thank you for clarifying just how little I know about access, very helpful and motivating.
 

Users who are viewing this thread

Back
Top Bottom