Results 1 to 4 of 4
  1. #1
    TOMMY.MYERS668's Avatar
    TOMMY.MYERS668 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Feb 2013
    Location
    West Virginia
    Posts
    77

    Output to pdf

    Okay I have my db creating a folder which I want to export my reports to in pdf format im trying to export the files and I get a vb error during the outputto code. My current cde is:

    Docmd.outputto acoutputreport,"certification checklist" ,".pdf", applicationcurrentproject.path and"\certification checklist.pdf",false

    All I get is compile error expected end of statement.
    Any ideas what I'm doing wrong I've also tried () around it then it expects an =

  2. #2
    TOMMY.MYERS668's Avatar
    TOMMY.MYERS668 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Feb 2013
    Location
    West Virginia
    Posts
    77

    Re: Output to pdf

    As an update code error gone but now it says can't find object ' certification checklist' and that is the exact name off the report.

  3. #3
    TOMMY.MYERS668's Avatar
    TOMMY.MYERS668 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Feb 2013
    Location
    West Virginia
    Posts
    77

    Re: Output to pdf

    Nevermind I think I got it . Now I just have to get it in the sub folder.

  4. #4
    TOMMY.MYERS668's Avatar
    TOMMY.MYERS668 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Feb 2013
    Location
    West Virginia
    Posts
    77
    Ok so it creates the pdf in the folder I want. But now I'm back to an old problem. It prints a report for all the records so I need a where type statement like I have with the open report command so it only creats the pdf for the current record... Any ideas?

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

Similar Threads

  1. Output to Excel from VBA
    By GraeagleBill in forum Programming
    Replies: 3
    Last Post: 10-08-2012, 03:33 PM
  2. MS Access to Excel Output
    By rjbautista20 in forum Programming
    Replies: 7
    Last Post: 02-22-2012, 07:23 PM
  3. Output query to list box
    By shabbaranks in forum Programming
    Replies: 4
    Last Post: 02-08-2012, 09:53 AM
  4. output file name
    By AdrianoG87 in forum Reports
    Replies: 4
    Last Post: 11-03-2011, 06:20 PM
  5. .txt output from report
    By dhopper in forum Reports
    Replies: 1
    Last Post: 08-05-2011, 12:01 PM

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