Using VBA to insert a hyperlink

[PortyAL]

Hi

I'm trying to use VBA (the HyperlinkPart function to be precise)to insert a hyperlink into a hyperlink field in a form.

I am trying the following code:

Forms![events log]!Link = HyperlinkPart("c:\folder\filename.doc", acAddress)
Forms![events log]!Link = HyperlinkPart("file", acDisplayedtext)

where "link" is the hyperlink field.

The acDisplayedText line works OK, but I cannot get the document path inserted. It is always blank.

Any advice would be appreciated.

Thanks

AL

 

[genomon]

HyperlinkPart returns values, not sets them.

The early bird may get the worm, but the second mouse gets the cheese in the trap.

 

[PortyAL]

Thanks

Any ideas how to set the values?

AL

 

[genomon]

Assuming you mean set the value in the underlying table, it is the same as updating or inserting any other field; just happens to be a different datatype.

Always remember that you're unique. Just like everyone else.

 

[PHV]

Have you tried this ?
Forms![events log]!Link = "file#c:\folder\filename.doc#"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PortyAL]

Many thanks - had left out the # arround the path.

AL