HyperLink String (edited question)

[ambushsinger]

I've captured a file path and file name using the Windows Open File dialog
box and saved this information to a field in an Access table as a Hyperlink.
My code saves the file path and file name as a Hyperlink in the Access table

My problem is that when I try to open this Hyperlink it won't open.
If I edit the Hyperlink and re-type the colon , for example: "C:\Fr2009.wmf"
then the Hyperlink works.
Does anyone know how to capture this file string and save it as a Hyperlink
so that it opens without being edited?
Help....

 

[Alex Dybenko]

hi,
you can to save hyperlink string as:

rst("myfield")="C:\Fr2009.wmf#C:\Fr2009.wmf#"

you can also read text of saved hyperlink to find the right syntax

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[ambushsinger]

Thanks Alex...
--
ambushsinger

hi,
you can to save hyperlink string as:

rst("myfield")="C:\Fr2009.wmf#C:\Fr2009.wmf#"

you can also read text of saved hyperlink to find the right syntax

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com