Solved

print attachment  with vba code

Posted on 2008-10-27
4
759 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 125 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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Obtaining SubForm Information from Main From 2 30
Access recordset not updateable 8 38
Dateadd 3 20
Sending Attachment via CDO 3 17
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
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…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
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…

705 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

16 Experts available now in Live!

Get 1:1 Help Now