> There are several possible issues here. Some depend on policies that you
> may not have permission to alter (depending on who manages your computer.)
>
> If you are opening a file, such as:
> C:\SomeFolder\SomFile.pdf
> it might make a difference if you form the complete hyperlink, including
> prepending the file:/// prefix.
>
> Details in:
> Hyperlinks: warnings, special characters, errors
> at:
>
http://allenbrowne.com/func-GoHyperlink.html>
> "Vic" <Vic[ at ]discussions.microsoft.com> wrote in message
> news:8B895F2C-E334-435F-B60D-823EC0196094[ at ]microsoft.com...
>> Awesome. That was exactly what I was looking for. Thx.
>>
>> Get a bit of another problem though. When you click on the hyperlink now
>> I
>> get this message. Hyperlink can be harmful to your computer and data.
>> To
>> protect your computer, click on those hyperlinks from trusted sources.
>> Do
>> you want to continue.
>>
>> I've looked at the database and trusted sources but how do you add it or
>> prevent this message ;(.
>>
>> Thx.
>>
>> First part was awesome them. Still excited about it. I know little
>> things
>> make me happy. Merry Christmas everyone and to you and yours Allen
>> especially.
>>
>> "Allen Browne" wrote:
>>
>>> Add these 2 lines to the Event Procedure code for the button's Click
>>> event:
>>>
>>> Me.[PutYourHyperlinkFieldTextBoxNameHere].SetFocus
>>> RunCommand acCmdInsertHyperlink
>>>
>>> "Vic" <Vic[ at ]discussions.microsoft.com> wrote in message
>>> news:37FE9BDC-CBB5-404D-B42C-C68B3BFDF12C[ at ]microsoft.com...
>>> > I've setup a field in one of my tables as a hyperlink and placed the
>>> > field
>>> > in
>>> > the form.
>>> >
>>> > We are currently scanning documents to PDF file and then we attach
>>> > those
>>> > files to lets say a client. However in order to do this we have to go
>>> > to
>>> > the
>>> > insert option on the menu bar and then select hyperlink. Then this
>>> > takes
>>> > us
>>> > to the database directory and from there we choice the directory that
>>> > the
>>> > pdf
>>> > file is in. Lastly we select the file and we're done.
>>> >
>>> > Here's the thing though. I would like to be able to setup on the
>>> > field in
>>> > the form a i.e. on double click that it those everything stated above
>>> > and
>>> > then all we have to do is select the file we want.
>>> >
>>> > Can anyone help with this. I've searched through the help menu but it
>>> > really doesn't reference doing anything like this. I know I need to
>>> > go to
>>> > the event tab and pick on double click and select code builder. I
>>> > don't
>>> > know
>>> > anything about how to write that code.