By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,508 Members | 2,949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,508 IT Pros & Developers. It's quick & easy.

run pdf file from ms access

P: n/a
Am trying to open an Adobe .pdf file from Access2000.

I use the following code:

Shell "C:\Program Files\Adobe\Acrobat 6.0\Acrobat\Acrobat.exe /c start
C:/Temp/Circulation summary.pdf"

This starts Adobe Acrobat fine - then I get a message that there was an
error opening the document and the file could not be found.

If I then clear the error message, the file is right there with no
problem.

Can some one help opening this file without gtting the error message in
the middle?

Thank you in advance.

Mike

Nov 16 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Mike wrote:
Am trying to open an Adobe .pdf file from Access2000.

I use the following code:

Shell "C:\Program Files\Adobe\Acrobat 6.0\Acrobat\Acrobat.exe /c start
C:/Temp/Circulation summary.pdf"

This starts Adobe Acrobat fine - then I get a message that there was an
error opening the document and the file could not be found.

If I then clear the error message, the file is right there with no
problem.

Can some one help opening this file without gtting the error message in
the middle?

Thank you in advance.

Mike
See if this code works better
http://www.mvps.org/access/api/api0018.htm
Nov 16 '06 #2

P: n/a
Have you tried:

application.followhyperlink "C:/Temp/Circulation summary.pdf"

Ron

Nov 16 '06 #3

P: n/a

Ron2006 wrote:
Have you tried:

application.followhyperlink "C:/Temp/Circulation summary.pdf"

Ron
That worked fine. Had to endure one warning about viruses and then had
to allow a hyperlink.

Thanks again for the help.

Nov 17 '06 #4

P: n/a

salad wrote:
Mike wrote:
Am trying to open an Adobe .pdf file from Access2000.

I use the following code:

Shell "C:\Program Files\Adobe\Acrobat 6.0\Acrobat\Acrobat.exe /c start
C:/Temp/Circulation summary.pdf"

This starts Adobe Acrobat fine - then I get a message that there was an
error opening the document and the file could not be found.

If I then clear the error message, the file is right there with no
problem.

Can some one help opening this file without gtting the error message in
the middle?

Thank you in advance.


Mike
See if this code works better
http://www.mvps.org/access/api/api0018.htm
Managed to get this working with that code with some minor changes.

Thank you.

Nov 17 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.