Results 1 to 9 of 9
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Location
    Ilkeston, Derbyshire
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    PDF reports (2000)

    Is it possible using code to output a report to PDF? It would need to seved to a particular place and have no user intervention. Or would I be better off just creating a snapshot file?

    TIA
    Mark

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: PDF reports (2000)

    See the thread starting at <post#=322048>post 322048</post#>. You can set the report to print to PDF. If you use Adobe software, specifying the destination file without user intervention requires fiddling with the registry; <post#=322094>post 322094</post#> in that thread contains example code and a link to an alternative.

  3. #3
    Star Lounger
    Join Date
    Mar 2003
    Location
    Ilkeston, Derbyshire
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PDF reports (2000)

    Thanks Hans
    I've had a quick look but haven't managed to get this to work yet. I'll have another go when I have a bit more time

    Mark

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: PDF reports (2000)

    If you can get the recipients to install the (free) snapshot viewer, creating a snapshot file is a lot easier to do in code than creating PDF. DoCmd.OutputTo lets you create a .snp file with a specified name in a specified location.

  5. #5
    Star Lounger
    Join Date
    Mar 2003
    Location
    Ilkeston, Derbyshire
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PDF reports (2000)

    Hans
    Most of the users have the snapshot viewer anyway so I reckon .snp files are the way to go.

    Thanks again
    Mark

  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: PDF reports (2000)

    I have just been doing some of this myself, and I found that using pdf995 (available from http://www.pdf995.com/ you can create files with no user intervention.

    You need to also download an additional utility PDFEdit995 which works as a configuration editor, to specify automatic filenaming rules.

    One option is to always use the same filename, then you could rename the file in code yourself.
    Regards
    John



  7. #7
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PDF reports (2000)

    I've been using CutePDF Writer for some months now which has no annoying popups or advertising.
    It's a free download which will create the document and save the path of your last document.
    It acts as a printer, so can be selected from your printer list.

  8. #8
    Star Lounger
    Join Date
    Mar 2003
    Location
    Ilkeston, Derbyshire
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PDF reports (2000)

    Thanks John, I'll give pdf995 a look

    Mark

  9. #9
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: PDF reports (2000)

    There is a free PDF driver out there for creating PDF files. Just to an internet search for "Free PDF Access"; that should find it.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •