[Resolved] Hyperlinking in Access

All I want to do is create a hyperlink field and update that field with links to files via code. Creating the field is no problem...updating it is.

Thru code I update each record with a file based hyperlink....strictly via assigning the string path. However, the hyperlink in the table is 'dead'...I expected this.

Searching thru the archives, I see references to using AppendChunk method to initiate the link. However my ADO or DAO recordset does not support that method.

I am missing something here? Any suggestions on how to update the record with the hyperlink?

Thanks,
ww

The "hyperlink" is nothing more than a string, stored in a text field, that, when retrieved, becames a path to a file? Is this correct?

No...the field data type is hyperlink. I attempted to assign a string for a particular record and the string does show as a hyperlink in the table. But when you click on the hyperlink nothing happens.

I got it. You can update a hyperlink field data type with just a string. You need to include the # symbol!

VB Code:

Do While Not rst.EOF
        rst.Edit
        'INCORRECT: rst![thelink] = "K:\HOME\rob\ylds\" & rst![StratumLink] & ".xls"
        rst![thelink] = "#K:\HOME\rob\ylds\" & rst![StratumLink] & ".xls#"
        rst.Update
        rst.MoveNext
    Loop

ww

Actually, I just found an MSDN link that pretty much states exactly what you just discovered.

Glad you got it figured out.