Results 1 to 6 of 6
  1. #1
    Nod_Swerdna is offline Novice
    Windows 8 Access 2007
    Join Date
    Feb 2015
    Posts
    27

    Question How do I save a Snapshot of the Current Form Contents to a PDF file

    I have written a program that calculates totals from information that is input to a form. I am able to print a picture of the form to save my work but I would like to be able to save the result to a PDF file to save paper. Does anyone have a VBA coding tip to do this.


    Thx, Don...

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    DoCmd.OutputTo acOutputReport, "rpt25+Anes", acFormatPDF, "Z:\Erx\Anes25+.pdf", False

  3. #3
    Rawb is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    Forms are not designed to be printed. You will need to create a Report first and then use ranman256's code to print that to a PDF.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,921
    Forms are not intended to be printed but can be - just as reports are not intended for screen viewing but can serve. In either case, recordset must be filtered or all records will output.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Nod_Swerdna is offline Novice
    Windows 8 Access 2007
    Join Date
    Feb 2015
    Posts
    27
    Thank you so much for your help. You guys are great.

  6. #6
    Nod_Swerdna is offline Novice
    Windows 8 Access 2007
    Join Date
    Feb 2015
    Posts
    27
    Thank you to ranman256 for this great bit of code. It works fine for me and solves my problem.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 01-12-2015, 12:54 PM
  2. Replies: 5
    Last Post: 04-18-2012, 12:04 PM
  3. Replies: 11
    Last Post: 03-29-2012, 11:23 PM
  4. get current file name
    By nkuebelbeck in forum Programming
    Replies: 3
    Last Post: 08-01-2011, 07:02 AM
  5. Replies: 1
    Last Post: 04-07-2010, 08:49 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums