> Please Help - Hyperlink Tables Not Working, Access 2010

[Alphix]

I have a simple form.

One text field box
One button (with macro)

Actions:

The User enters the file name for example: "1"

the enter button concatenate the address to the file name and also enters the address to the table.
When I go to the table the Hyperlink does not work. The type on the table field is Hyperlink and it still does not work.


The cursor changes to a hand button the hyperlink actions does not process.
The only time it works, I have to manually go to the table and delete a character and re-enter it back then press enter.

I do not know why it does not work.
Please see attachment

Desktop.zip

[cyanidem]

For hyperlink field to work, string has to be in proper format:

Descriptive text#Link#

So in your case:

C:\Users\NAME\Desktop\Place\1.pdf#C:\Users\NAME\Desktop\Place\1.pdf#

Change your button code to:

Private Sub Command2_Click()
Dim sSql As String
Dim X As String
Dim B As String
Dim C As String
B = "C:\Users\NAME\Desktop\Place\"
C = ".pdf"
X = B & Me.Text0.Value & C
X = X & "#" & X & "#"
sSql = "INSERT INTO HLinkTable ([AddressF]) VALUES ('" & X & "')"
       Debug.Print sSql
       CurrentDb.Execute sSql, dbFailOnError
       'FollowHyperlink X
Me.Text0.Value = ""
End Sub

[Alphix]

Wow....That piece of the code blew my mind. If you have the time, can you explain how that work? : X = X & "#" & X & "#"



But Million thanks anyway.

Alphix

[cyanidem]

It simply concatenates your previously assigned X value (string) with itself and creates a new string for X. Nothing extraordinary.

[Alphix]

Many thanks again :-)