• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 805
  • Last Modified:

print attachment with vba code

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
darkprowler
Asked:
darkprowler
  • 2
  • 2
1 Solution
 
peter57rCommented:
The pdf integration in A2007 allows you to print TO a pdf, not FROM a pdf.
0
 
darkprowlerAuthor Commented:
okay   not good
what about printing attachment if you have adobe acrobat installed , will that do any difference
0
 
peter57rCommented:
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
 
darkprowlerAuthor Commented:
hi peter
well yes this works fine , just hoped there was a way not to  use shell

thanks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now