If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hyperlink field in a table
We have a hyperlink field set up to link to documents in a specific folder,
do to some issues we have to change the name of the folder. With changing the name of the folder it makes us have to change the path of all the hyperlinks (there is about 2000, so manually going in and editing them would be a big hastle). In the field, we have the title stored and if you click on that it takes you to the document. Is there an easy to change the names of all the paths?? Is there a way to display the path to the hyperlink in the filed, so I may do a find/replace?? Any help would be appreciated. |
#2
|
|||
|
|||
Roger
Have you tried using the Replace choice on the Edit menu? You should be able to use the "...any part..." choice to find something (your pathname) within the string in the hyperlink field. This should give you a global search/replace capability for that field. Good luck Jeff Boyce Access MVP "Roger" wrote in message ... We have a hyperlink field set up to link to documents in a specific folder, do to some issues we have to change the name of the folder. With changing the name of the folder it makes us have to change the path of all the hyperlinks (there is about 2000, so manually going in and editing them would be a big hastle). In the field, we have the title stored and if you click on that it takes you to the document. Is there an easy to change the names of all the paths?? Is there a way to display the path to the hyperlink in the filed, so I may do a find/replace?? Any help would be appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Unable to edit records in a form or query | Merlin | Using Forms | 7 | May 10th, 2005 02:00 PM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
Update Tables using forms | achett | Using Forms | 5 | January 28th, 2005 12:25 AM |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
create hyperlink: "predefined text string+number field from the table" | Uriel TK | General Discussion | 1 | September 5th, 2004 10:01 PM |