Results 1 to 3 of 3
  1. #1
    JosmithTwo is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    19

    How to output a report to .pdf printer with a specific directory path and file name?

    I have the below DoCmd in Access 2003. The default printer is CutePDF. I want to specify the directory path and file name so the user does not have to provide the input for each report.



    If this is possible in Access 2010 or 2013 Let me know as well.

    DoCmd.OpenReport "rpt_ObjectivesReport", acViewNormal, , "ClientNo='12345'"

    Jim

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,913
    I know that can be done with OutputTo method, which can create a PDF of report and save to specific folder/filename. I don't know that Access can pass that info to CutePDF.

    Have you tried creating PDF with OutputTo?
    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.

  3. #3
    JosmithTwo is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    19
    Thanks. That helped. I can use OutputTo and in access 2007 there's an add-on for pdf output. Skips cutePdf altogether.

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

Similar Threads

  1. Replies: 3
    Last Post: 12-16-2013, 09:44 AM
  2. Replies: 13
    Last Post: 12-12-2013, 07:22 PM
  3. Replies: 10
    Last Post: 10-07-2013, 08:20 AM
  4. Replies: 1
    Last Post: 05-14-2013, 11:49 AM
  5. Replies: 6
    Last Post: 10-26-2012, 12:53 PM

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