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

x
?
Solved

print attachment  with vba code

Posted on 2008-10-27
4
Medium Priority
?
799 Views
Last Modified: 2013-11-27
In access 2007 it is possible to very easy save an attachment
but how can you print that attachment  (pdf)  , have heard that  pdf is intregrated in access 2007
can't seem to find anything about this , anywhere
anyone have any ideas
0
Comment
Question by:darkprowler
  • 2
  • 2
4 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 22812149
The pdf integration in A2007 allows you to print TO a pdf, not FROM a pdf.
0
 

Author Comment

by:darkprowler
ID: 22812933
okay   not good
what about printing attachment if you have adobe acrobat installed , will that do any difference
0
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 22813950
You can do..
Dim x
x = Shell("c:\program files\adobe\reader 9.0\reader\AcroRd32.exe /t c:\folder\file.pdf")

(Obviously you must use your own path for the acrobat reader.)
0
 

Author Comment

by:darkprowler
ID: 22814322
hi peter
well yes this works fine , just hoped there was a way not to  use shell

thanks
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

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.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

824 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