Hi All, I am having issues with making use of hyperlink object in an Update SQL.
I have a form where a user pastes the URL to a drawing in a text box. I have a table, Drawings, with fields "ID" and "Links".
The link will be transferred to the field in the table corresponding to the ID they selected in a combo box. I can have the raw url appear in the field but I want a Display text to show "Link" over the URL.
If IsNull(Me.cmboID) = True Then
Else
Dim updatesql As String
updatesql = "Update Drawings Set Links = {Hyperlink stuff??}" & me.txtlink & " Where [ID] = " & Me.cmboID & ""
DoCmd.RunSQL updatesql
End If
I'm not quite sure how to aggregate texttodisplay and address in a single SQL statement.
I have a form where a user pastes the URL to a drawing in a text box. I have a table, Drawings, with fields "ID" and "Links".
The link will be transferred to the field in the table corresponding to the ID they selected in a combo box. I can have the raw url appear in the field but I want a Display text to show "Link" over the URL.
If IsNull(Me.cmboID) = True Then
Else
Dim updatesql As String
updatesql = "Update Drawings Set Links = {Hyperlink stuff??}" & me.txtlink & " Where [ID] = " & Me.cmboID & ""
DoCmd.RunSQL updatesql
End If
I'm not quite sure how to aggregate texttodisplay and address in a single SQL statement.