Access Report to PowerPoint?

[kwvh]

I am using Access 2010. I can't find any obvious ways of sending graphs created in Access to Powerpoint, but feel like this is something that users would want. Is there something there and I just don't see it?

Thanks!

[HansV]

If you have a chart on a report, make sure that its Enabled property is set to Yes.
Display the report in Report View. (You can't use Print Preview, for that is not interactive)

If you have a chart on a form, make sure that its Enabled property is set to Yes.
Display the form in Form View.

In both situations:
Right-click the chart, select Copy, then switch to PowerPoint and paste.

[Egg 'n' Bacon]

I'm guessing this is new in 2010?

[HansV]

Report View was introduced in Access 2007, I think.

[Egg 'n' Bacon]

Report View is in 2007, though I can't seem to find the ...

Aha! Got it!

Cheers Hans, I have been after something like this for a while.

[kwvh]

Hans,

Thanks! Ah, if life were only so simple. I have a form AND a report based on the form that has four charts, in a 4 quadrant arrangement. In the best of all worlds, I would like to use Office Automation / VBA to send the form or report or the four graphs to a single slide in Powerpoint. Is that something that might be possible with enough skill and luck?

[kwvh]

Hans,

Following your instructions, I was able to copy the graphs one at a time and paste them into a single slide, then resized each graph to take up one quarter of the screen. Tedious, but accomplishes the goal. However, I would like to find a way to automate it, as training folks with minimal computer skills is going to be tough.

Thanks!

[HansV]

You could do the following on the Access side for a form:

Me.ChartControl1.SetFocus
RunCommand acCmdCopy

This selects the chart control named ChartControl1 and copies it to the clipboard.

You can then use Automation to paste it onto a slide in PowerPoint.

(If users can't be taught how to copy and paste, anything is going to be tough...)

[kwvh]

Hans,
I will play with that approach. It might work.
RE:users can't be taught.
Some remind me of elephants, i.e. fearful of a mouse. And sometimes I wonder how they find their way to work and back home again. But that is a discussion for another time.