Question Access to PowerPoint Automation

[theone]

Hello All,

I have an interesting scenario that I could use your help on:

I need to be able to have the capability to generate a PowerPoint Presentation by clicking on a button within a form in Access. These slides need to be automatically generated from existing data in Access. I am not terribly familiar with Access, so any assistance is greatly appreciated, especially concerning the VBA code necessary to accomplish this - I have also listed two sites which I only found mildly helpful (given my lack of VBA experience):

http://support.microsoft.com/default.aspx?scid=kb;en-us;209960

http://www.databaselessons.com/access-data-to-powerpoint-1.php

Thanks!

 

[theone]

UPDATE:

I have managed to implement a button on an Access form which generates a series of slides (based on source code from MS site), however I would appreciate any input as to how I can generate a PPT presentation based on the data currently on the form. If I am being somewhat unclear, please let me know.

 

[DCrake]

Don't knnow if you have the same link but here is a demo on how to do the PPT exercise.

http://www.access-programmers.co.uk/forums/showthread.php?t=162648

 

[theone]

Thanks for the file DCrake,

This might help, however for some reason I am unable to utilize the button, as every time I click on it, I get compile error: "can't find project or library" If you could please clarify how to get this example up and running, it would be appreciated.

Thanks,

theone

 

[theone]

Just wanted to know if anyone else may have any other suggestions..last bump..thanks

 

[DCrake]

Have you checked your references for missing objects?

 

[theone]

Yes, I am missing the Microsoft Graph 11.0 Object Library and the Microsoft PowerPoint 11.0 Object Library

I am using Access 2000

 

[DCrake]

Then use the ones that are available to you. Even if it is an earlier version.

 

[theone]

Unfortunately, I cannot get it to work with the 9.0 version libraries..however much thanks for the input and advice