Getting Access/database data in a PowerPoint table?

[Guest]

I've got a report that I generate every day here at work, that represents the
current health status of certain systems that we are responsible for. The
data that this report comes from is in a Access 2000 database, which is
updated twice daily. the report that we turn in is in Powerpoint format
(again Powerpoint 2000). What I would like to know is, is there a way that
whenever the Powerpoint presentation is opened, it draws from the Access
database where the information is located, and placed in a table on a slide?
Any help would be greatly appreciated. Thanks.

 

[Guest]

Powerpoint in itself doesn't have any capabilities for accessing data from
external sources such as Access databases. However, you can insert a
Microsoft Excel 2000 worksheet or chart onto your powerpoint presentation
that gets the data from your Microsof Access database.

 

[Guest]

Thanks, Chester....

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.

Thanks again!!

Chris

 

[Steve Rindsberg]

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

 

[Guest]

Steve,

Thanks, this will work perfectly for me. All I have to do is make a few
modifications and everything will be working.

Chris

 

[Steve Rindsberg]

Steve,

Thanks, this will work perfectly for me. All I have to do is make a few
modifications and everything will be working.

Nice bit of work from Naresh, isn't it?