Using VBA to set an Access Hyperlink Field 1

[RikHess]

I am trying to programmatically build the hyperlink Display_Text and Address for records as they are processed.

I have a hyperlink type field named "Link" in the table.

Using an ADODB recSet, I am trying to assign values to this field so that the field will display "GoTo_Link" and the URL would be "file:///C:\MyFolder\Sonefile.txt".

This does not work:
recSet.Fields("Link") = HyperlinkPart("GoTo_Link", acDisplayText)
recSet.Fields("Link") = HyperlinkPart("file:///C:\MyFolder\Sonefile.txt", acAddress)


Does someone have an answer? Any help is appreciated. TIA!

 

[VBslammer]

A Hyperlink field is nothing more than a Memo field with special formatting. The separate parts of the link are separated by hash marks:
[tt]
DisplayName#Address[?Subject]#SubAddress##ScreenTip
[/tt]

recSet.Fields("Link") = "GoTo_Link#file:///C:\MyFolder\Sonefile.txt#"

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[RikHess]

THANKS!
It is easy -- once you see it work.

 

[VBslammer]

And that's why I love Professor Bob's motto: "You just have to know which screws to turn."

VBSlammer

"You just have to know which screws to turn." - Professor Bob