Populate Slide from MS Access

[Guest]

Hello.

I know this is a Power Point group, but just wanted to cover all bases...

I have an Access database that is used to keep track of seating numbers in a
conference (among other things). The database populates a report that has a
graphic of the conference room with the names of the participants under their
respective seat number.

Problem is, there are about 200 seats on the report which means about 200
controls. I have come to realize that I have met the limit of the number of
controls an Access report can have, before it basically craps out (and don't
even think about doing this over a network...CRASH!)

I was wondering if it was possible to populate a Power Point slide with the
data from Access and if so, how is it done.

Any help would be appreciated.

Thanks in advance,

Mike

 

[Kurt]

Sure, have a look at DataPoint at http://www.PresentationPoint.com
With DataPoint you can link your presentation to MS Access to populate your
slides and graphs.

Otherwise you will have to use the PPT object model to populate your objects
with vba or vb

Kurt.

 

[Steve Rindsberg]

Hello.

I know this is a Power Point group, but just wanted to cover all bases...

I have an Access database that is used to keep track of seating numbers in a
conference (among other things). The database populates a report that has a
graphic of the conference room with the names of the participants under their
respective seat number.

Starting with a pre-made slide with the needed number of shapes and text boxes,
you could programatically change each of the text boxes to the name of the
participant (or just add their name to the shape representing the chair if that
works better for you).

Shouldn't be all that hard to do.