Re: Getting Access/database data in a PowerPoint table?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

This doesn't help me that much. I always thought that all the Microsoft
Office products were co-related, in that they could all work with each others
data. I guess there might be some other way I could do this, perhaps through
vba or something.

Probably so. Have a look here:

Controlling Office Applications from PowerPoint (by Access MVP Naresh Nichani)
http://www.pptfaq.com/FAQ00795.htm

It includes sample code for extracting data from Access and bringing it into PPT.

Then there's the matter of "Where do I put the code so it's always available to the
user?" That means creating a PowerPoint add-in.

Creating and Installing Add-ins, Toolbars, Buttons
http://www.pptfaq.com/index.html#name_Creating_and_Installing_Add-ins-_Toolbars-_But
tons

And finally you'll have to work out how to trigger the update. AutoOpen subroutines
in add-ins trigger whenever the add-in loads, but that only happens at PPT startup.
In order to have the Access code fire only when a particular presentation opens,
you'd need to trap the presentation open event and do some kind of test to determine
whether the presentation is "The One" or just any ole bag 'o slides.

Make PPT respond to events
http://www.pptfaq.com/FAQ00004.htm

And to ID "The One", you might simply apply a tag to the presentation and have the
event handler test for it.

To tag it:

Call ActivePresentation.Tags.Add("PresentationID","TheOne")

And in the event handler:

If ActivePresentation.Tags("PresentationID") = "TheOne" Then
' do your stuff
End If

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================


.

Quantcast