Results 1 to 5 of 5
  1. #1
    wwjd77414 is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2012
    Posts
    3

    Question How to place a form into powerpoint using vba

    Hello!

    I have made a powerpoint presentation from inside Access. I have a form that populates the fields based on user input. I would like to put a copy of this form into a powerpoint slide after the data has updated. Is there a way to do this?? I have tried numerous code variations and can't seem to get anything to work.
    I am using Office 2003. My supervisors are comfortable with the display of the form the way it is. So I really need to use a picture of the form and not just the info contained in the form (otherwise i would just fill the slide with the data from the query)
    I have searched all over the web looking for a solution.


    Thanks!!!!!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Can't export to PowerPoint. You can screen print then paste the image into PowerPoint page and crop the image.
    http://www.ehow.com/how_5968529_conv...owerpoint.html

    Also review http://msdn.microsoft.com/en-us/libr...ffice.11).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
    wwjd77414 is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2012
    Posts
    3
    June7, I actually used portions of the code from MSDN site. It works great to create and populate slides. The screen print, paste and crop works to manually insert form but I was really needing to automate this from inside access. I would have thought with both Access and Powerpoint being Microsoft products and in the same suite, that this would be possible somehow.
    I tried using acCmdCopy and acDoCmd.MenuItem... and both resulted in errors. Do you know of a way to pass the screen print and paste through code??
    Thanks again !!

    Loren

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Closest I have seen is copy/paste into Access from clipboard. Review https://www.accessforums.net/program...ect-27704.html
    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
    wwjd77414 is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2012
    Posts
    3
    I will look at that and see where it takes me.
    Thanks for the info!!!

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

Similar Threads

  1. Exporting data to powerpoint
    By sharmaprashant22 in forum Import/Export Data
    Replies: 0
    Last Post: 05-03-2011, 12:28 AM
  2. Replies: 21
    Last Post: 02-14-2011, 02:51 PM
  3. Replies: 3
    Last Post: 11-17-2010, 05:21 PM
  4. Pivot table graph form export to powerpoint
    By maati1980 in forum Forms
    Replies: 0
    Last Post: 10-22-2009, 02:59 AM
  5. Replies: 0
    Last Post: 02-21-2008, 09:52 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