Creating shapes in PPT from Access 2010

[Tiger955]

Hi!

Here is my project:
For a duty plan the employees are assigned to positions in a certain area.

For example:
Name. Position. Description. Map
Brown. 1. backdoor. 1
Miller. 3. frontdoor. 1
Norman. 4. left wing. 2
Hoover. 6. right door. 2

....

Now I want to show the positions within circles on the maps, with the names within dynamically, as the employees change every week.

The coordinates of the positions do not change, but not every position is needed in every duty plan.

So, my idea is to draw all possible shapes on all possible maps and make them visible or not depending on the assignement.

The duty plan is my table in access and looping through all records I would like to fill the needed shapes.

All maps are on slides (40 slides and about 400 positions) and should be filled accordingly.

I can open my presentation, although I only could do it by late binding ( a reference to ppt 14 obj. Lib fails with an error!! - why??) but I cannot any solution how to loop through the records and do the job.

Please help me on doing this.

Thanks
Michael

 

[spikepl]

I don't quite see the point in creating shapes in PowerPoint using VBA. Modifying their properties is probably easier.

Prepare one typical slide as you want it, and in PowerPoint vba dive into the PowerPoint Object Model (google it) to find out how to navigate to and modify relevant bits. Once you can do that, then it should be a piece of cake to do likewise from Access.

 

[Tiger955]

Spike, you might be right!

Meanwhile I was also thinking about MS VIsion, which might be even more suitable, but as we have already the PPT whith the shapes on it, I will try it that way.

Thanks!
Michael