Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

AccessVB: Open/Print pdf files from Access.mdb

Posted on 2008-06-09
3
Medium Priority
?
462 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 2000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

971 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