Prev: Update Query Problem
Next: Headers In Multiple Column Reports - And Hiding On No data
From: Mark Andrews on 19 Jul 2010 18:54
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(a)hotmail.com> wrote in message
news:4c436797$0$7662$bf4948fe(a)news.tele2.nl...
> 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
>
>
From: David W. Fenton on 20 Jul 2010 12:48
Salad <salad(a)oilandvinegar.com> wrote in
news:6dadnRYfZZM3LdnRnZ2dnUVZ_hadnZ2d(a)earthlink.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/
From: Tony Toews on 21 Jul 2010 01:42
On Sun, 18 Jul 2010 22:44:12 +0200, "Simon van Beek"
<SvanBeekNL(a)hotmail.com> wrote:

>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/
From: jbguernsey on 21 Jul 2010 13:00
On Jul 20, 5:48 pm, "David W. Fenton" <XXXuse...(a)dfenton.com.invalid>
wrote:
> Salad <sa...(a)oilandvinegar.com> wrote innews:6dadnRYfZZM3LdnRnZ2dnUVZ_hadnZ2d(a)earthlink.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
From: David W. Fenton on 21 Jul 2010 13:41
jbguernsey <jeff(a)angelsystems.co.uk> wrote in
news:07ad7e4a-b63f-40e1-9beb-145aec1fa1a0(a)i31g2000yqm.googlegroups.co
m:

> 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/
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Update Query Problem
Next: Headers In Multiple Column Reports - And Hiding On No data