Access 2003, Trouble with Hyperlinks to Word Documents

[Respite Barb]

In an access 2003 DB for employees, I started linking supervision records
created in Microsoft Word to a record in an Access form. For the first 6
months of using the DB, the links worked fine. Of course I'd get the
customary warning about "opening hyperlinks is dangerous to your db" message,
but after clicking okay, the document would always open. Now, I get a
secondary message box with an error message that reads "Unable to open
specified file".

The difference between the hyperlinks that were first inserted into the
Access record and now is that the hyperlink address is preceded by two dots,
i.e.
...//Supervision

The DB and the supervision records are stored on a shared file. I can't
figure out why this won't work in spite of trying numerous guesses. I need
help. Thanks for any light you can shed.
Sincerely,

 

[Arvin Meyer MVP]

You can use ShellExecute to open the file without having to deal with
hyperlinks and their associated problems:

http://www.mvps.org/access/api/api0018.htm

You can also use just a plain text file path and tell Access to treat it as
a hyperlink:

Private Sub Form_Current()
Me.Label1.HyperlinkAddress = Me.Text2
End Sub

By using Label1 this way, you can click it and go to the path shown in Text2
textbox.

 

[Arvin Meyer MVP]

Post back if you need more help. Please post the names of your forms and
controls, and the names and path of a documents.