hyperlink update?

[gs_fusion]

Help!

One of our users has a database with 4000 records in a table that
includes one field that contains hyperlinks (data type) to unique
network files. Management decided to rename one of the directories in
the file paths and now of course all of the links are broken.

Is there an update query expression, a macro expression, or code that
will enable me to automatically update these hyperlink paths.

I was able to update the "text" of the hyperlink but of course that
didn't change the path itself.

Any help would be appreciated!

Mark

 

[Arvin Meyer]

Help!

One of our users has a database with 4000 records in a table that
includes one field that contains hyperlinks (data type) to unique
network files. Management decided to rename one of the directories in
the file paths and now of course all of the links are broken.

Is there an update query expression, a macro expression, or code that
will enable me to automatically update these hyperlink paths.

I was able to update the "text" of the hyperlink but of course that
didn't change the path itself.

I'm afraid the only help I can give you is to convert the hyperlink to text
and then use follow hyperlink code to make it act as if it were a hyperlink.
Something like the following:

Private Sub cmdHyperlink_Click()
Dim strPath As String
If Not IsNull(Me.txtBoxName) Then
strPath = Me.txtBoxName
Me.cmdHyperlink.HyperlinkAddress = strPath
End If
End Sub

This code uses the hyperlink property of a command button to act upon the
text as if the text were the hyperlink.

We had a salesman that took it upon himself to do the exact same thing as
your management after showing the bosses how this stupid mistake cost almost
$2,000 in lost time the salesman was then told never to touch the file
structure again Tell you management to do something useful with their time,
like getting a complete picture before they act precipitously.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[gs_fusion]

LOL.....

.. Thanks Arvin! I will try you suggestion(s). Don't know if management
will listen to me though