H
HWhite
There is a master db that has a table I want to link to. In that table is a
docpath field that is a hyperlink that works. I did not design this original
db and I cannot change anything with this original db. This db resides on a
doc server.
I created a new db (local workstation) and linked to the table. The
hyperlink does not work. The original hyperlink is not in a unc or drive
letter format. They look like this
"E-File%20Indices/1568/Pleadings/020207-1568-11-19-07-Pleadings.PDF" but they
work on the original db. Not in the linked table. I don't REALLY care about
that as long as I can do a text find/replace in the hyperlink field to
replace "E-File%20Indices/1568" with "t:\", and replace any "/" with "\". IF
I can do that, it will work just fine with a drive mapping (t:\) I have
created.
I would assume to do this I would need a form with a command button to
perform a new table query that opens the linked table, runs the new table
query, performs the rename process, and then saves and opens the resulting
new table in datasheet format. I need help with how to do the renaming
programatically.
Thank you very much and I hope this isn't too confusing.
docpath field that is a hyperlink that works. I did not design this original
db and I cannot change anything with this original db. This db resides on a
doc server.
I created a new db (local workstation) and linked to the table. The
hyperlink does not work. The original hyperlink is not in a unc or drive
letter format. They look like this
"E-File%20Indices/1568/Pleadings/020207-1568-11-19-07-Pleadings.PDF" but they
work on the original db. Not in the linked table. I don't REALLY care about
that as long as I can do a text find/replace in the hyperlink field to
replace "E-File%20Indices/1568" with "t:\", and replace any "/" with "\". IF
I can do that, it will work just fine with a drive mapping (t:\) I have
created.
I would assume to do this I would need a form with a command button to
perform a new table query that opens the linked table, runs the new table
query, performs the rename process, and then saves and opens the resulting
new table in datasheet format. I need help with how to do the renaming
programatically.
Thank you very much and I hope this isn't too confusing.