Prev: Special TIMESTAMP - 0912291327
Next: Sharepoint security settings to distribute Access database
From: Finn on 29 Dec 2009 16:03
Does anyone know how to open an extern file from a formular?
I have a formular with a field containing a filename related to a pdf
file in a directory c:\goods\drawings

I would like a button that opens the pdf file.
From: Salad on 29 Dec 2009 16:12
Finn wrote:

> Does anyone know how to open an extern file from a formular?
> I have a formular with a field containing a filename related to a pdf
> file in a directory c:\goods\drawings
>
> I would like a button that opens the pdf file.

This might get you started.
http://www.mvps.org/access/api/api0018.htm

From: Albert D. Kallal on 30 Dec 2009 16:55

"Finn" <finnchr(a)gmail.com> wrote in message
news:4b3a6e8b$0$36582$edfadb0f(a)dtext01.news.tele.dk...
> Does anyone know how to open an extern file from a formular?
> I have a formular with a field containing a filename related to a pdf file
> in a directory c:\goods\drawings
>
> I would like a button that opens the pdf file.

Just use:

Application.FollowHyperlink "c:\goods\drawings\help.pdf"


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal(a)msn.com


From: Bernard Peek on 31 Dec 2009 04:08
On 30/12/2009 21:55, Albert D. Kallal wrote:
> "Finn"<finnchr(a)gmail.com> wrote in message
> news:4b3a6e8b$0$36582$edfadb0f(a)dtext01.news.tele.dk...
>> Does anyone know how to open an extern file from a formular?
>> I have a formular with a field containing a filename related to a pdf file
>> in a directory c:\goods\drawings
>>
>> I would like a button that opens the pdf file.
>
> Just use:
>
> Application.FollowHyperlink "c:\goods\drawings\help.pdf"

OP is looking for a technique using a formula. Something like this would do:


BaseDir ="c:\docs\PDF\"

FileName ="fred"

Application.FollowHyperlink BaseDir & Filename & ".pdf"

In a real application FileName would probably have a value retrieved
from the database.


--
bap(a)shrdlu.com
From: Finn on 10 Jan 2010 13:21
Bernard Peek skrev:
> On 30/12/2009 21:55, Albert D. Kallal wrote:
>> "Finn"<finnchr(a)gmail.com> wrote in message
>> news:4b3a6e8b$0$36582$edfadb0f(a)dtext01.news.tele.dk...
>>> Does anyone know how to open an extern file from a formular?
>>> I have a formular with a field containing a filename related to a pdf
>>> file
>>> in a directory c:\goods\drawings
>>>
>>> I would like a button that opens the pdf file.
>>
>> Just use:
>>
>> Application.FollowHyperlink "c:\goods\drawings\help.pdf"
>
> OP is looking for a technique using a formula. Something like this would
> do:
>
>
> BaseDir ="c:\docs\PDF\"
>
> FileName ="fred"
>
> Application.FollowHyperlink BaseDir & Filename & ".pdf"
>
> In a real application FileName would probably have a value retrieved
> from the database.
>
>
Thank you for your respond - great help :-)
/Finn
 | 
Pages: 1
Prev: Special TIMESTAMP - 0912291327
Next: Sharepoint security settings to distribute Access database