Hyperlink Warning

[Rob]

Hello All,

I have a text field that has the is hyperlink property set to yes. When I
click on the hyperlink I get the warning about hyperlnks being unsafe, blah,
blah, blah. I need to use a text field because my data is coming from SQL
(no hyperlink field type in SQL). Is there a way to turn off the warning?

Thanks,

Rob

 

[Klatuu]

What are you trying to do with the hyperlink?
If you are using it to start an application or go to a web site, this works
for me:
http://www.mvps.org/access/api/api0018.htm

 

[Rob]

I am opening jpeg files.

What are you trying to do with the hyperlink?
If you are using it to start an application or go to a web site, this works
for me:
http://www.mvps.org/access/api/api0018.htm

 

[Klatuu]

Have you downloaded the code and tried it?

 

[Rob]

I think that I will use the registry option. All of the files are on a
network drive so the full path will be used to locate them. Adding the
DisableHyperlinkWarning to the registry seems to work if the files are not
local. I want the user to just click on the textbox and open the picture. I
can set the property Is Hyperlink to yes and the textbox becomes a hyperlink
object. If I did use the code how would I point my textbox data to the
variable stFile?

Thank you,

Rob

 

[Klatuu]

Me.MyTextBox = stFile

 

[Rob]

Would you just use the On Click of the textbox to run the code or would you
add a button to open the file?