Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Open an external file from a formular

18 views
Skip to first unread message

Finn

unread,
Dec 29, 2009, 4:03:05 PM12/29/09
to
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.

Salad

unread,
Dec 29, 2009, 4:12:26 PM12/29/09
to
Finn wrote:

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

Albert D. Kallal

unread,
Dec 30, 2009, 4:55:33 PM12/30/09
to

"Finn" <fin...@gmail.com> wrote in message
news:4b3a6e8b$0$36582$edfa...@dtext01.news.tele.dk...

Just use:

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


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOO...@msn.com


Bernard Peek

unread,
Dec 31, 2009, 4:08:27 AM12/31/09
to
On 30/12/2009 21:55, Albert D. Kallal wrote:
> "Finn"<fin...@gmail.com> wrote in message
> news:4b3a6e8b$0$36582$edfa...@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.


--
b...@shrdlu.com

Finn

unread,
Jan 10, 2010, 1:21:44 PM1/10/10
to
Bernard Peek skrev:
Thank you for your respond - great help :-)
/Finn
0 new messages