By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Access Reports into Powerpoint

P: n/a
Is there anyway to convert/export/copy an Access report into a
Powerpoint slide?

I know I can publish via Excel/Word but these remove formatting etc
and therefore always require some degree of manipulation.

My report data obviously changes from time to time and I want to avoid
having to reformat/update manually.

Thanks
John
Nov 13 '05 #1
Share this Question
Share on Google+
10 Replies


P: n/a
I would too be interested in an answer to this.

At the moment, I print the document to a pdf using pdf995 and then copy the
information into Powerpoint. This works for reports and graphs from Access.

The other way I tried was to use automation and create the reports directly
in Word / Excel.

hth

Chris
"John Smith" <jo********@hotmail.com> wrote in message
news:67*************************@posting.google.co m...
Is there anyway to convert/export/copy an Access report into a
Powerpoint slide?

I know I can publish via Excel/Word but these remove formatting etc
and therefore always require some degree of manipulation.

My report data obviously changes from time to time and I want to avoid
having to reformat/update manually.

Thanks
John

Nov 13 '05 #2

P: n/a
There is a detailed article and a couple of KB articles on the MS site
dealing with publishing reports to Snapshot format where the reports
will be updated on a regular basis.

Less complex, would be to embedd the Snapshot ActiveX control, one on
each Slide of your presentation. Setup each control to point to the
propert page of your report.

Another alernative would be to use the ReportUtilities on my site to
publish your Report to a series of Enhanced Metafiles(EMF's), one for
each page of your report. The result is the same as exporting to
Snapshot format. EMF's are directly insertable onto your Slide and are
fully scaleable/resolution independant. You could automate the process
completely with abit of VBA code.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"John Smith" <jo********@hotmail.com> wrote in message
news:67*************************@posting.google.co m...
Is there anyway to convert/export/copy an Access report into a
Powerpoint slide?

I know I can publish via Excel/Word but these remove formatting etc
and therefore always require some degree of manipulation.

My report data obviously changes from time to time and I want to avoid
having to reformat/update manually.

Thanks
John


Nov 13 '05 #3

P: n/a
> I know I can publish via Excel/Word but these remove formatting etc
and therefore always require some degree of manipulation.


I guess it depends what you're aiming for. Your choices are:

* Take a screen shot of the report, and paste the image into PPT.
Crop the window edges.

* Export your data to html, or xml, and use a css to apply the
formatting.

* Write OLE Automation code to post your Access data into PowerPoint
through VBA code.
Nov 13 '05 #4

P: n/a
Am having some success at exporting reports to word as a generic operation.
I can export text, labels, pictures and rtf2 controls reasonably well, but I
am struggling with sub reports at the moment although, a solution is in
sight. Everything is editable in the word document.
Would really like an expert to take it on as a project as I suspect I am
writing the code in a very amateurish way.

Dare say the same techniques could be used with PowerPoint

Phil
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:cG**********************@ursa-nb00s0.nbnet.nb.ca...
There is a detailed article and a couple of KB articles on the MS site
dealing with publishing reports to Snapshot format where the reports
will be updated on a regular basis.

Less complex, would be to embedd the Snapshot ActiveX control, one on
each Slide of your presentation. Setup each control to point to the
propert page of your report.

Another alernative would be to use the ReportUtilities on my site to
publish your Report to a series of Enhanced Metafiles(EMF's), one for
each page of your report. The result is the same as exporting to
Snapshot format. EMF's are directly insertable onto your Slide and are
fully scaleable/resolution independant. You could automate the process
completely with abit of VBA code.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"John Smith" <jo********@hotmail.com> wrote in message
news:67*************************@posting.google.co m...
Is there anyway to convert/export/copy an Access report into a
Powerpoint slide?

I know I can publish via Excel/Word but these remove formatting etc
and therefore always require some degree of manipulation.

My report data obviously changes from time to time and I want to avoid
having to reformat/update manually.

Thanks
John

Nov 13 '05 #5

P: n/a
I have tried the screen shot but depending on the font/print
format/cropping process/resizing the results can be variable.

Thanks for your suggestions though - I have also tried the others but
with little success.

I am reading Access VBA for Dummies so hope might find a few pointers
there.

It's a shame that that Chapter 14 - Integrating with other Office
Applications - covering Word, Excel and Outlook doesn't extend to
Powerpoint.

It maybe thought that I can export to Excel and link this to
Powerpoint as a way that might be possible for me with limited
knowledge of vba & some of the more advanced aspects of Access.

Thanks everyone
Nov 13 '05 #6

P: n/a
One of my fellow team members attempted to shove snapshot files into
powerpoint. It REALLY didn't like that (so he said).

Another option could be to output the data to XL, format the XL sheet
to be pretty, and then paste it as a link into the slide. I've done
it before and it doesn't look too bad. You can make it fairly
seemless except for the whole "Do you want to update links?" thing.

Anthony.

Th*********@gmail.com (Thug Passion) wrote in message news:<b0**************************@posting.google. com>...
I know I can publish via Excel/Word but these remove formatting etc
and therefore always require some degree of manipulation.


I guess it depends what you're aiming for. Your choices are:

* Take a screen shot of the report, and paste the image into PPT.
Crop the window edges.

* Export your data to html, or xml, and use a css to apply the
formatting.

* Write OLE Automation code to post your Access data into PowerPoint
through VBA code.

Nov 13 '05 #7

P: n/a
Phil I have little practical experience in Automation with Word but I
would like to take a look at your current solution to see your progress
over the last months. I did take time this summer to study a book on the
Word object model. Perhaps there is something I can add to your solution

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:41*********************@mercury.nildram.net.. .
Am having some success at exporting reports to word as a generic operation. I can export text, labels, pictures and rtf2 controls reasonably well, but I am struggling with sub reports at the moment although, a solution is in sight. Everything is editable in the word document.
Would really like an expert to take it on as a project as I suspect I am writing the code in a very amateurish way.

Dare say the same techniques could be used with PowerPoint

Phil
"Stephen Lebans" <Fo****************************************@linval id.com> wrote in message

news:cG**********************@ursa-nb00s0.nbnet.nb.ca...
There is a detailed article and a couple of KB articles on the MS site dealing with publishing reports to Snapshot format where the reports
will be updated on a regular basis.

Less complex, would be to embedd the Snapshot ActiveX control, one on each Slide of your presentation. Setup each control to point to the
propert page of your report.

Another alernative would be to use the ReportUtilities on my site to
publish your Report to a series of Enhanced Metafiles(EMF's), one for each page of your report. The result is the same as exporting to
Snapshot format. EMF's are directly insertable onto your Slide and are fully scaleable/resolution independant. You could automate the process completely with abit of VBA code.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"John Smith" <jo********@hotmail.com> wrote in message
news:67*************************@posting.google.co m...
Is there anyway to convert/export/copy an Access report into a
Powerpoint slide?

I know I can publish via Excel/Word but these remove formatting etc
and therefore always require some degree of manipulation.

My report data obviously changes from time to time and I want to avoid having to reformat/update manually.

Thanks
John



Nov 13 '05 #8

P: n/a
Thanks for coming back, Stephen

I will sort out the relevent bits of the Db and send them off to you within
a couple of days

Phil
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:1C**********************@ursa-nb00s0.nbnet.nb.ca...
Phil I have little practical experience in Automation with Word but I
would like to take a look at your current solution to see your progress
over the last months. I did take time this summer to study a book on the
Word object model. Perhaps there is something I can add to your solution

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:41*********************@mercury.nildram.net.. .
Am having some success at exporting reports to word as a generic

operation.
I can export text, labels, pictures and rtf2 controls reasonably well,

but I
am struggling with sub reports at the moment although, a solution is

in
sight. Everything is editable in the word document.
Would really like an expert to take it on as a project as I suspect I

am
writing the code in a very amateurish way.

Dare say the same techniques could be used with PowerPoint

Phil
"Stephen Lebans"

<Fo****************************************@linval id.com>
wrote in message

news:cG**********************@ursa-nb00s0.nbnet.nb.ca...
> There is a detailed article and a couple of KB articles on the MS site > dealing with publishing reports to Snapshot format where the reports
> will be updated on a regular basis.
>
> Less complex, would be to embedd the Snapshot ActiveX control, one on > each Slide of your presentation. Setup each control to point to the
> propert page of your report.
>
> Another alernative would be to use the ReportUtilities on my site to
> publish your Report to a series of Enhanced Metafiles(EMF's), one for > each page of your report. The result is the same as exporting to
> Snapshot format. EMF's are directly insertable onto your Slide and are > fully scaleable/resolution independant. You could automate the process > completely with abit of VBA code.
>
> --
>
> HTH
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "John Smith" <jo********@hotmail.com> wrote in message
> news:67*************************@posting.google.co m...
>> Is there anyway to convert/export/copy an Access report into a
>> Powerpoint slide?
>>
>> I know I can publish via Excel/Word but these remove formatting etc
>> and therefore always require some degree of manipulation.
>>
>> My report data obviously changes from time to time and I want to avoid >> having to reformat/update manually.
>>
>> Thanks
>> John
>


Nov 13 '05 #9

P: n/a
> It's a shame that that Chapter 14 - Integrating with other Office
Applications - covering Word, Excel and Outlook doesn't extend to
Powerpoint.

It's probably because Powerpoint has sort of a different object model
than some of the other apps, and probably doesn't get used as much.
But once you get past the obvious differences ( tables, worksheets,
pages, slides, email messages ) the whole Office family works pretty
much the same way.
Nov 13 '05 #10

P: n/a
>
Another option could be to output the data to XL, format the XL sheet
to be pretty, and then paste it as a link into the slide. I've done
it before and it doesn't look too bad. You can make it fairly
seemless except for the whole "Do you want to update links?" thing.

Anthony.


Yes - this is the method that I'm using at the moment - thanks
everyone for their comments.
John
Nov 13 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.