MS Access - How to turn a Dataset/query table into an OLE Object? msAcess 2000

Question

I have some VB that copies OLEobjects into powerpoint automatically for me. The purpose of this is that my database runs queries, and then forms turn them into charts. As it runs through the various queires/form on open/close events the charts are added to a powerpoint presentation.

I also have parallel queries that show the resulting data in datasheet form, and I was wondering if there is a way to turn that into an OLE object (like the charts) so that I can have this thing automatically add these to the powerpoint to.

The basic idea is that I am copying and pasting into the notes section of the powerpoint for each relative slide (chart w/data), and I am wondering if there is a better way to do it?

The reason I ask about this "OLE idea/method" is that the OLEobject = copy is the only way I have been able to get this thing to automate the powerpoint side of it (or, it's the only way I know how to do it).

Any advice is always appreciated!

Answer 1

I guess you could use code like this:

DoCmd.OpenForm "FormName", acFormDS

DoCmd.RunCommand acCmdSelectAllRecords

DoCmd.RunCommand acCmdCopy

Then paste as a table into PowerPoint.

Another option would be to open a recordset object and build a Table filling in the cells.

Please see this MSDN link with an example