A particular challenge I have is to automate Access to create PowerPoint slides. I have two reports in one database, sometimes these reports are 1 to 4 pages long. I need to run this every morning. The areas that I have been reviewing have not been very helpful, although I have been successful in created pieces of record sets throughout multiple slides (ex: 100 rows of data results in 100 slides).

Any suggestions, answers or pointers will be most helpful. Until then, I will continue searching and experimenting.

FYI...Access 2003 to PowerPoint 2007.