PC Review


Reply
Thread Tools Rate Thread

Create A PowerPoint Presentation with Access Data

 
 
=?Utf-8?B?UkFN?=
Guest
Posts: n/a
 
      2nd Apr 2006
I have been able to create a PowerPoint presentation using the following
code, but I would like to include Images in the presentation. The code shows
how to insert the text but I don't understand how to insert images from a
separate field.

Thanks in advance for any help.

Dim db As Database, rs As Recordset
Dim ppObj As PowerPoint.Application
Dim ppPres As PowerPoint.Presentation

'On Error GoTo err_cmdOLEPowerPoint

' Open up a recordset on the Employees table.
Set db = CurrentDb
Set rs = db.OpenRecordset("VideoTable", dbOpenDynaset)

' Open up an instance of Powerpoint.
Set ppObj = New PowerPoint.Application
Set ppPres = ppObj.Presentations.Add

' Setup the set of slides and populate them with data from the
' set of records.
With ppPres
While Not rs.EOF
With .Slides.Add(rs.AbsolutePosition + 1, ppLayoutTitle)
.Shapes(1).TextFrame.TextRange.Text = "Hi! Page " &
rs.AbsolutePosition + 1
.SlideShowTransition.EntryEffect = ppEffectFade
With .Shapes(2).TextFrame.TextRange
.Text = CStr(rs.Fields("QUES").Value)
.Characters.Font.Color.RGB = RGB(255, 0, 255)
.Characters.Font.Shadow = True
End With
.Shapes(1).TextFrame.TextRange.Characters.Font.Size = 50
End With
rs.MoveNext
Wend
End With

' Run the show.
ppPres.SlideShowSettings.Run

Exit Sub

err_cmdOLEPowerPoint:
MsgBox Err.Number & " " & Err.Description

--
AccessRAM
 
Reply With Quote
 
 
 
 
TC
Guest
Posts: n/a
 
      3rd Apr 2006
That's really a PowerPoint VBA question, as much as an Access one.

See if this helps:
http://groups.google.com/group/micro...age+vba&qt_g=1

How I found that PowerPoint newsgroup:
http://tc2.atspace.com/0013-HowToSea...#FindNewsgroup

HTH,
TC (MVP Access)
http://tc2.atspace.com

 
Reply With Quote
 
=?Utf-8?B?TGluZHNheSBtYW5sZXk=?=
Guest
Posts: n/a
 
      19th Apr 2006
can you give me a web to go to so i can get on to it thank you

"TC" wrote:

> That's really a PowerPoint VBA question, as much as an Access one.
>
> See if this helps:
> http://groups.google.com/group/micro...age+vba&qt_g=1
>
> How I found that PowerPoint newsgroup:
> http://tc2.atspace.com/0013-HowToSea...#FindNewsgroup
>
> HTH,
> TC (MVP Access)
> http://tc2.atspace.com
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Access data to live powerpoint presentation?? james Microsoft Access 4 24th Nov 2009 06:41 AM
Integrate Access data into Powerpoint presentation Tfrup12 Microsoft Access 9 25th Sep 2008 06:52 PM
How do I create a PowerPoint presentation? =?Utf-8?B?SmFlaw==?= Microsoft Powerpoint 4 28th Mar 2006 01:16 AM
Can I create a DVD from a powerpoint presentation =?Utf-8?B?eWJrZXI=?= Microsoft Powerpoint 2 5th Feb 2005 05:32 PM
Create PowerPoint Slides with MS Access Data Lillith Microsoft Access 0 9th Jul 2003 12:20 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:32 AM.