Results 1 to 4 of 4
  1. #1
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    839

    Access Form to Powerpoint

    June7,


    Yes I have read through the links you have posted. I did use the search button. The MSDN one seemed the best, but I do not want to have to do 5 seperate clicks (Buttons) for each slide. My report deviates from 1 to 5 or more depending on circumstances.

    I am wanting to do this with one report, and to have it end up on a PPT slide(s) with 1 click. Snapshot is not the answer. What I'd like to get is WYSIWYG from the Access Printview to PPT.

    Or if Powerpoint can pull data from an Access table, that may work as well. Just open the PowerPoint Template and save the file, email out as needed. That might be worth it.


    Both ways would work

    Thanks

  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,822
    Is this one link I already provided https://microsoftaccessexpert.com/Mi...utomation.aspx
    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
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    839
    No I didn't see that one. Let me check it out. Thanks

  4. #4
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    839
    June7,
    I didn't feel like paying to get the code. So I am trying to work from what was given. Unless someone already has the code.....

    I changed the ppt to pptx. I am thinking that the "DIM pptx" As is another module not given that makes pptx as a variable. I am also thinking you must use the DAO code to set the dB, and the form you are using. I am guessing as the following code gets a user defined error on PPTX.

    On Error GoTo doPowerPointAutomationErr
    Dim strTemplateFile As String
    Dim strFileName As String
    strTemplateFile = Application.CurrentProject.Path & "\MyExistingPPTXFile.ppt"
    strTemplateFile = Application.CurrentProject.Path & "\MyNewPPTXFile.ppt"
    Dim pptx As New PowerPoint.Application
    Dim pptxPresentation As PowerPoint.Presentation
    With pptx
    .Visible = True
    .WindowState = ppWindowMinimized
    Set pptxPresentation = .Presentations.Open(strTemplateFile)
    With pptPresentation
    pptxPresentation.Slides(2).Delete
    pptxPresentation.SaveAs strFileName
    Shell "explorer.exe " & strFileName, vbNormalFocus
    pptxPresentation.Close
    End With
    Set pptxPresentation = Nothing
    End With
    pptx.Quit
    Set ppt = Nothing
    doPowerPointAutomationExit:
    Exit Sub
    doPowerPointAutomationErr:
    MsgBox Err.Description, vbOKOnly, Err.Source & ":" & Err.Number
    Resume doPowerPointAutomationExit
    End Sub

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

Similar Threads

  1. Access Reports into Powerpoint
    By karthik in forum Reports
    Replies: 1
    Last Post: 11-28-2014, 11:36 AM
  2. insert a powerpoint presentation into access
    By ecalvert47462 in forum Access
    Replies: 3
    Last Post: 12-04-2012, 02:09 PM
  3. How to place a form into powerpoint using vba
    By wwjd77414 in forum Access
    Replies: 4
    Last Post: 09-03-2012, 04:41 PM
  4. Linking Access/Powerpoint 2010... Possible?
    By William McKinley in forum Access
    Replies: 1
    Last Post: 03-13-2012, 02:44 PM
  5. Pivot table graph form export to powerpoint
    By maati1980 in forum Forms
    Replies: 0
    Last Post: 10-22-2009, 02:59 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