Way pdf file not will stay permanent open

#1

Dear reader,

The following VBA instruction opens a file.

Application.FollowHyperlink X:\.............\FileName.Extension

Only in case the extension is pdf than the file opens and immediately the
file is closing.

Is there any one who knows way the extension PDF will not stay open as all
other extension will do.

Kind regards,

Simon

#2

Simon van Beek wrote:

Quote:

Dear reader,

The following VBA instruction opens a file.

Application.FollowHyperlink X:\.............\FileName.Extension

Only in case the extension is pdf than the file opens and immediately the
file is closing.

Is there any one who knows way the extension PDF will not stay open as all
other extension will do.

Kind regards,

Simon

Don't know. You could copy the code at

http://www.mvps.org/access/api/api0018.htm into a module and do
something like
? fHandleFile("C:\filename.pdf",3)

#3

"Simon van Beek" <SvanBeekNL (AT) hotmail (DOT) com> wrote

Quote:

Dear reader,

The following VBA instruction opens a file.

Application.FollowHyperlink X:\.............\FileName.Extension

Only in case the extension is pdf than the file opens and immediately the
file is closing.

Is there any one who knows way the extension PDF will not stay open as all
other extension will do.

Kind regards,

Simon

It may be a Windows issue and not Access. I use the same code to open files,
including PDF.

#4

Salad <salad (AT) oilandvinegar (DOT) com> wrote in
news:gZKdna1SAqG2F97RnZ2dnUVZ_qadnZ2d (AT) earthlink (DOT) com:

Quote:

Simon van Beek wrote:

Dear reader,

The following VBA instruction opens a file.

Application.FollowHyperlink X:\.............\FileName.Extension

Only in case the extension is pdf than the file opens and
immediately the file is closing.

Is there any one who knows way the extension PDF will not stay
open as all other extension will do.

Don't know. You could copy the code at
http://www.mvps.org/access/api/api0018.htm into a module and do
something like
? fHandleFile("C:\filename.pdf",3)

Does the ShellExecute API behave differently from
Application.FollowHyperlink? I always thought the latter was just a
very thin wrapper around the former.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

#5

David W. Fenton wrote:

Quote:

Salad <salad (AT) oilandvinegar (DOT) com> wrote in
news:gZKdna1SAqG2F97RnZ2dnUVZ_qadnZ2d (AT) earthlink (DOT) com:

Simon van Beek wrote:

Dear reader,

The following VBA instruction opens a file.

Application.FollowHyperlink X:\.............\FileName.Extension

Only in case the extension is pdf than the file opens and
immediately the file is closing.

Is there any one who knows way the extension PDF will not stay
open as all other extension will do.

Don't know. You could copy the code at
http://www.mvps.org/access/api/api0018.htm into a module and do
something like
? fHandleFile("C:\filename.pdf",3)

Does the ShellExecute API behave differently from
Application.FollowHyperlink? I always thought the latter was just a
very thin wrapper around the former.

I got the same deal as the OP with a PDF. Using FollowHyperlink,even
specifying open in new window, it would open and then be minimized. Not
with a .txt file or .doc as they'd open restored.

With the function I provided from MVPS you can specify how you want the
file opened. And it handles PDFs just fine.

#6

I thought there was a bug with certain versions of Adobe Reader and using
followhyperlink.
I can't find the link on Microsoft's site but I seem to remember this issue.

However I would use the shell method (I think it works better).

--
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

"Simon van Beek" <SvanBeekNL (AT) hotmail (DOT) com> wrote

Quote:

Dear reader,

The following VBA instruction opens a file.

Application.FollowHyperlink X:\.............\FileName.Extension

Only in case the extension is pdf than the file opens and immediately the
file is closing.

Is there any one who knows way the extension PDF will not stay open as all
other extension will do.

Kind regards,

Simon

#7

Salad <salad (AT) oilandvinegar (DOT) com> wrote in
news:6dadnRYfZZM3LdnRnZ2dnUVZ_hadnZ2d (AT) earthlink (DOT) com:

Quote:

David W. Fenton wrote:
Does the ShellExecute API behave differently from
Application.FollowHyperlink? I always thought the latter was just
a very thin wrapper around the former.

I got the same deal as the OP with a PDF. Using
FollowHyperlink,even specifying open in new window, it would open
and then be minimized. Not with a .txt file or .doc as they'd
open restored.

I don't see this. Mayber there are differences in versions of Adobe
Reader?

Quote:

With the function I provided from MVPS you can specify how you
want the file opened. And it handles PDFs just fine.

Yes. The ShellExecute API allows you to specify window mode, so if
that's a problem with Application.FollowHyperlink, that's a big
plus.

Has anyone tried alternatives to Adobe Reader, like Foxit? I
haven't, but have been tempted.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

#8

On Sun, 18 Jul 2010 22:44:12 +0200, "Simon van Beek"
<SvanBeekNL (AT) hotmail (DOT) com> wrote:

Quote:

Application.FollowHyperlink X:\.............\FileName.Extension

Only in case the extension is pdf than the file opens and immediately the
file is closing.

What happens when you click on the PDF file directly from within
Windows Explorer?

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

#9

On Jul 20, 5:48*pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid>
wrote:

Quote:

Salad <sa... (AT) oilandvinegar (DOT) com> wrote innews:6dadnRYfZZM3LdnRnZ2dnUVZ_hadnZ2d (AT) earthlink (DOT) com:

David W. Fenton wrote:
Does the ShellExecute API behave differently from
Application.FollowHyperlink? I always thought the latter was just
a very thin wrapper around the former.

I got the same deal as the OP with a PDF. *Using
FollowHyperlink,even specifying open in new window, it would open
and then be minimized. *Not with a .txt file or .doc as they'd
open restored.

I don't see this. Mayber there are differences in versions of Adobe
Reader?

With the function I provided from MVPS you can specify how you
want the file opened. *And it handles PDFs just fine.

Yes. The ShellExecute API allows you to specify window mode, so if
that's a problem with Application.FollowHyperlink, that's a big
plus.

Has anyone tried alternatives to Adobe Reader, like Foxit? I
haven't, but have been tempted.

--
David W. Fenton * * * * * * * * *http://www.dfenton.com/
usenet at dfenton dot com * *http://www.dfenton.com/DFA/

David

I've been using Foxit for PDFs for a couple of years now. It's much
quicker than Adobe and has worked fine for me with PDFs in Access.

JB

#10

jbguernsey <jeff (AT) angelsystems (DOT) co.uk> wrote in
news:07ad7e4a-b63f-40e1-9beb-145aec1fa1a0 (AT) i31g2000yqm (DOT) googlegroups.co
m:

Quote:

I've been using Foxit for PDFs for a couple of years now. It's
much quicker than Adobe and has worked fine for me with PDFs in
Access.

I had downloaded it twice before and never installed it!

I just tried it and it renders certain kinds of problematic PDFs
onscreen more clearly than Adobe Reader ever did. So I just made it
my default PDF reader/plugin.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/