Hyperlink field does not work

[hefly]

I have created a hyperlink field in my table (tbl_ChkRequests) using hyperlink datatype. The field shows the blue hyperlink but clicking on that field does nothing.

I manually added # sign both before and after the sting which allows the hyperlink to function. Hovering over the field with screen tips does not reveal the # signs I placed before and after the path.

I then created an update query to place the # signs before and after the path string. I ran the query but the resulting link does not work.
My table has too many records to manually manipulate the path field.

This is the update to criteria I used in my Update Query: UPDATE tbl_ChkRequests SET tbl_ChkRequests.Path = "#" & [Path2] & "#";


Can someone please advise how to create a functioning hyperlink field?

Thank you very much.

Hefly

 

[hefly]

I am able to open the root folder using the hyperlink, but cannot open the subfolders.

For example, in the immediate window,the following folder will not open (10033.73 is a folder name):

Application.FollowHyperlink "\\MyComputer\Project\_00000\_Check Requests\10033.73\"

However, the root folder will open with this command:

Application.FollowHyperlink "\\MyComputer\Project\_00000\_Check Requests"

Please advise...

Thank you.

Hefly

 

[hefly]

I think I have solved my own problem... The subfolder names in my table were abbreviated. My hyperlinks are working properly.

Hefly