turn off warning

[brino]

hi all !

i am using a hyperlink to open another database from the database that
is being used by my client.
when the client does this it brings up a warning message about opening
hyperlinks saying that they could be dangerous etc. etc.
how can i stop this message coming up every time the hyperlink is
clicked.
this will be a source of frustration for my client and i have to stop
the messages somehow.
i have looked in the security settings of access and i cant find how i
can turn them off .
how can i do this ???

thanks
brino

 

[Allen Browne]

There are several possible scenarios here, but the first step is to ensure
you have formed the hyperlink correctly and included the correct prefix.

A hyperlink consists of 3 or 4 parts, separated by #.
The acAddress part (middle one) needs to include the prefix, e.g.:
http://
file:///

 

[brino]

There are several possible scenarios here, but the first step is to ensure
you have formed the hyperlink correctly and included the correct prefix.

A hyperlink consists of 3 or 4 parts, separated by #.
The acAddress part (middle one) needs to include the prefix, e.g.:
http://
file:///

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.








- Show quoted text -

thanks allen but the hyperlink is ok it works fine.
i just need to get rid of the warning that comes up and i dont know
how i can do this ?
thanks
brino

 

[Allen Browne]

Access will still work the hyperlink (even if it's just a text field), but
it will give the warnings if you don't form the address correctly.

 

[brino]

Access will still work the hyperlink (even if it's just a text field), but
it will give the warnings if you don't form the address correctly.

thanks Allen this worked really well !

thanks again
brino

 

[Amy E. Baggott]

I have the same problem. I have a hyperlink field in a table that is a
different value for each record. The middle part of the hyperlink (after the
display text and #) does start with "http://", but I still get the warning.
The workaround I have come up with is to store the hyperlink path as text,
then create a label with the following code in the "On Click" property:

Dim stAppName As String

stAppName = "C:\Program Files\Internet Explorer\iexplore.exe " &
Me.Contract
Call Shell(stAppName, 1)

where Me.Contract is the text field containing the hyperlink path. I
started out by creating a button using the command button wizard and the Run
App option to open IE, but then copied the code into the On Click property of
a label because a label takes up less room and looks cleaner on the form when
you have a whole row of them.

This way, nobody gets the warning from Access, although IE still gives a
warning about opening files. The IE warning is a lot less intimidating to
look at, though because it doesn't include all the gobbledygook that makes up
the hyperlink.

Is there a more elegant way to do this, or should I just stick with what
works for me?

 

[Tom Wickerath]

Hi Amy,

Have you tried Application.FollowHyperlink stAppName?


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________