Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Print PDF from within Access

Discussion in 'Information Technology' started by Si, Nov 16, 2005.

  1. Si

    Si
    Expand Collapse
    Guest

    Is it possible to print a PDF file from within Access 97?
     
  2. Loading...

    Similar Threads Forum Date
    In The Footprints Of Guru Nanak- Fourth Journey In Punjab Sikh Sikhi Sikhism Dec 22, 2016
    In The Footprints Of Guru Nanak-Fourth Itinerary Sikh Sikhi Sikhism Dec 18, 2016
    Footprints Of Guru Nanak In Sri Lanka History of Sikhism May 27, 2016
    Sikhism Preserving the Sikh heritage in Print Sikh Sikhi Sikhism Jan 12, 2016
    Guru Nanak's Foot-Prints in Baghdad's Sands Blogs Oct 22, 2015

  3. OP
    Lynn Trapp

    Lynn Trapp
    Expand Collapse
    Guest

  4. OP
    Rick B

    Rick B
    Expand Collapse
    Guest

    Yes, but you have to use third-party software. Use something like
    "cutepdf.exe" which creates a virtual printer.


    --
    Rick B



    "Si" <si@hello.com> wrote in message
    news:Ox2IB2f6FHA.2600@tk2msftngp13.phx.gbl...
    > Is it possible to print a PDF file from within Access 97?
    >
     
  5. OP
    Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Lynn and Rick both assumed you mean "can you print a report to a PDF file".

    I'm wondering, though, whether you meant "can I have Access programmatically
    tell Adobe Acrobat to print a PDF file". If that is what you meant, then as
    long as you know where Acrobat is installed, you can.

    The command line method to have Acrobat print a file is:

    "full path to AcroRd32.exe" /p /h "full path to PDF file"

    If the full path to the PDF file is stored in a variable strFile, you could
    do something like:

    Dim strShell As String

    strShell = Chr$(34) & _
    "C:\Program Files\Adobe\Acrobat 6.0\ReaderAcroRd32.exe" & _
    Chr$(34) & " /p /h " & Chr$(34) & strFile & Chr$(34)
    Shell strShell, vbHide

    Note that there are blanks before and after /p /h in the string above.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Si" <si@hello.com> wrote in message
    news:Ox2IB2f6FHA.2600@tk2msftngp13.phx.gbl...
    > Is it possible to print a PDF file from within Access 97?
    >
    >
     
  6. OP
    tina

    tina
    Expand Collapse
    Guest

    take a look at

    http://www.lebans.com/reporttopdf.htm

    hth


    "Si" <si@hello.com> wrote in message
    news:Ox2IB2f6FHA.2600@tk2msftngp13.phx.gbl...
    > Is it possible to print a PDF file from within Access 97?
    >
    >
     
  7. OP
    Lynn Trapp

    Lynn Trapp
    Expand Collapse
    Guest

    tina,
    I don't think Stephen has the A97 version available yet, but says it is
    coming soon.

    --
    Lynn Trapp
    MS Access MVP
    www.ltcomputerdesigns.com
    Access Security: www.ltcomputerdesigns.com/Security.htm
    Jeff Conrad's Access Junkie List:
    http://home.bendbroadband.com/conradsystems/accessjunkie.html



    "tina" <nospam@address.com> wrote in message
    news:17pef.105545$zb5.41273@bgtnsc04-news.ops.worldnet.att.net...
    > take a look at
    >
    > http://www.lebans.com/reporttopdf.htm
    >
    > hth
    >
    >
    > "Si" <si@hello.com> wrote in message
    > news:Ox2IB2f6FHA.2600@tk2msftngp13.phx.gbl...
    >> Is it possible to print a PDF file from within Access 97?
    >>
    >>

    >
    >
     
  8. OP
    Joe Cilinceon

    Joe Cilinceon
    Expand Collapse
    Guest

  9. OP
    tina

    tina
    Expand Collapse
    Guest

    oops!


    "Lynn Trapp" <ltrapp_NOSPAM@ltcomputerdesigns.com> wrote in message
    news:%232yQc6g6FHA.2092@TK2MSFTNGP12.phx.gbl...
    > tina,
    > I don't think Stephen has the A97 version available yet, but says it is
    > coming soon.
    >
    > --
    > Lynn Trapp
    > MS Access MVP
    > www.ltcomputerdesigns.com
    > Access Security: www.ltcomputerdesigns.com/Security.htm
    > Jeff Conrad's Access Junkie List:
    > http://home.bendbroadband.com/conradsystems/accessjunkie.html
    >
    >
    >
    > "tina" <nospam@address.com> wrote in message
    > news:17pef.105545$zb5.41273@bgtnsc04-news.ops.worldnet.att.net...
    > > take a look at
    > >
    > > http://www.lebans.com/reporttopdf.htm
    > >
    > > hth
    > >
    > >
    > > "Si" <si@hello.com> wrote in message
    > > news:Ox2IB2f6FHA.2600@tk2msftngp13.phx.gbl...
    > >> Is it possible to print a PDF file from within Access 97?
    > >>
    > >>

    > >
    > >

    >
    >
     
  10. OP
    Joe Cilinceon

    Joe Cilinceon
    Expand Collapse
    Guest

    Joe Cilinceon wrote:
    > The pdf995 site has the code to print out any report from access to
    > PDF995 listed at
    > http://pdf995.com/faq_dev.html It is the last question on the page
    > with a link to the module code.
    >
    > http://pdf995.com/index.html You can get pdf995 here


    Oh the method I posted with work in all versions though some modifactions
    are necessary. They are noted in the code on what to change for various
    versions.

    --

    Joe Cilinceon
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page