Populate a Power Point Slide

[Guest]

Hello.

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

 

[John Nurick]

Hi Mike,

If the room is laid out as a simple rectangular grid with the same
number of seats in each row, use a report that has just one row of seats
in its detail section and feed it with one record for each row.

If the layout isn't that simple, can it be adequately represented on a
rectangular grid? If so, how about using Excel with some cunning use of
cell colours and borders. A pair of cells for each seat, one for the
number and the other for the name ... and some reasonably simple
Automation code to insert the names against the right seats.

If the layout needs to be fancier, I'd recommend using Visio rather than
PowerPoint.