Results 1 to 4 of 4
  1. #1
    GinaFlan is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2014
    Location
    Texas
    Posts
    68

    Button Created code to open and preview report. Is there code for button to generate or save as pdf?

    I used code below for a button to open and preview a report. Can I code a button to save or view it as a pdf?


    Private Sub CmdReport_Click()
    Select Case Me.ComboSummary
    Case "Child Nutrition"
    DoCmd.OpenReport "Child Nutrition Report", acViewPreview


    End Select

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Yes, explore the OutputTo method.
    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
    GinaFlan is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2014
    Location
    Texas
    Posts
    68
    Ok great thank you

  4. #4
    hansendl is offline Advanced Hobbyist
    Windows 7 64bit Access 2010 32bit
    Join Date
    Sep 2012
    Posts
    38
    Look at the DoCmd.OutputTo method.

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

Similar Threads

  1. Replies: 5
    Last Post: 04-09-2014, 09:42 AM
  2. code to open table from Command Button
    By DMJ in forum Database Design
    Replies: 1
    Last Post: 02-20-2014, 12:33 PM
  3. Code for button to open new form passing value
    By cptNemo in forum Programming
    Replies: 3
    Last Post: 09-13-2012, 09:46 PM
  4. Replies: 7
    Last Post: 11-23-2011, 08:14 PM
  5. Replies: 2
    Last Post: 06-09-2011, 09:47 AM

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