T
themartellekid
I have a table with 2 fields, one is a primary key to join another table in a
query, the other is a hyperlink field with a text display. For example, T04
is the text displayed for the hyperlink which points to c:/temp/to4.pdf.
However, while importing the Excel spreadsheet that stored the links,
c:/temp/t04.pdf got 'lost', I don't know why. So all that is left is the blue
hyperlink text T04. I could manually edit all the hyperlinks but there are
over 700 records, plus I want to know if there is a way to do it easily.
OK, so I want to update the underlying hyperlink but not the text that shows
in table. I have set the base hyperlink for the database to c:/temp and when
you click the link it opens Window Explorer to the c:/temp directory. How do
I update the hyperlink to point to the t04.pdf file and open it? Manually I
would just right click and edit the hyperlink. And how do I do it for all 700
records that have different text; T05, T06, etc. There are multiple T0
numbers (t04 might be in more than one record.
Access 2003 is the version.
query, the other is a hyperlink field with a text display. For example, T04
is the text displayed for the hyperlink which points to c:/temp/to4.pdf.
However, while importing the Excel spreadsheet that stored the links,
c:/temp/t04.pdf got 'lost', I don't know why. So all that is left is the blue
hyperlink text T04. I could manually edit all the hyperlinks but there are
over 700 records, plus I want to know if there is a way to do it easily.
OK, so I want to update the underlying hyperlink but not the text that shows
in table. I have set the base hyperlink for the database to c:/temp and when
you click the link it opens Window Explorer to the c:/temp directory. How do
I update the hyperlink to point to the t04.pdf file and open it? Manually I
would just right click and edit the hyperlink. And how do I do it for all 700
records that have different text; T05, T06, etc. There are multiple T0
numbers (t04 might be in more than one record.
Access 2003 is the version.