Solved

AccessVB: Open/Print pdf files from Access.mdb

Posted on 2008-06-09
3
390 Views
Last Modified: 2013-11-27
I would like to open and print a pdf file using Access VB. But the code I submitted below does not work, will someone help me make it work?

Shell ("C:\Program Files\Adobe\Acrobat 8.0\Acrobat\acrobat.exe H:\Deliveries\Exxo\P6-9-08 Sams 33-0-9-DEL-2008.pdf")

Is there a way to open the pdf. without using shell? ( If I give my Access.mdb to someone who has installed adobe in a different location, it will not work)
0
Comment
Question by:ouestque
  • 2
3 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 21744652
Application.Followhyperlink "H:\Deliveries\Exxo\P6-9-08 Sams 33-0-9-DEL-2008.pdf"
0
 

Author Comment

by:ouestque
ID: 21744922
Thanks!
0
 

Author Closing Comment

by:ouestque
ID: 31465459
Thank you so much!!!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now