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
10  15766 
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********@hot mail.com> wrote in message
news:67******** *************** **@posting.goog le.com... 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
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********@hot mail.com> wrote in message
news:67******** *************** **@posting.goog le.com... 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
> 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.
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************ *************** *************@l invalid.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********@hot mail.com> wrote in message
news:67******** *************** **@posting.goog le.com... 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
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
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*********@gma il.com (Thug Passion) wrote in message news:<b0******* *************** ****@posting.go ogle.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.
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********@sta ntonfamily.co.u k> wrote in message
news:41******** *************@m ercury.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************ *************** *************@l invalid.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********@hot mail.com> wrote in message
news:67******** *************** **@posting.goog le.com... 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
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************ *************** *************@l invalid.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********@sta ntonfamily.co.u k> wrote in message
news:41******** *************@m ercury.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************ *************** *************@l invalid.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********@hot mail.com> wrote in message
> news:67******** *************** **@posting.goog le.com...
>> 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
>
> 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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Joris Kempen |
last post by:
Hi people,
I know that the question has come around sometimes:
How to open an Access Report using ASP and export it to for example
RTF.
I'm trying to implement the first method of David Cline:
http://www.15seconds.com/issue/981216.htm
|
by: cyranoVR |
last post by:
This is the approach I used to automate printing of Microsoft Access
reports to PDF format i.e. unattended and without annoying "Save As..."
dialogs, and - more importantly - without having to use a commercial
program such as Adobe Acrobat and its associated API.
The technique uses Ghostscript and Redirection Port Monitor - two free
programs for creating PDF documents provided free by Russell Lang. The
actual automation requires VBA...
|
by: Steven Taylor |
last post by:
Hope someone can help.
I have an application whereby in order to create one document type I
effectively print out 3 or 4 access reports in correct order. So the
user goes to the printer, collects the report and has no idea that 3 or
4 reports were actually created in order to produce the printed copy.
I now have a need to send that same report to a 'Snapshot' file. Is
there a way to combine separate Access reports and have them...
|
by: Brian Barnes |
last post by:
I've been searching using google trying to find a way to display
Access Reports via ASP.NET and only finding commericial products which
appear to require that the report needs to be converted every time
that a change is made (this is not ideal for my situation).
What I need is something that references the access reports (the data
itself is in MS SQL Server) and will display them.
Some of the solutions to this I have come across are...
|
by: David |
last post by:
Does anyone know how to run MS Access reports from VB.net. I'd like to keep
the existing reports in the database if I can.
Thanks
David
| | |
by: dkurtz |
last post by:
D. Lesandrini published an article some time ago about exporting Access
reports as XML, and then updating those XML reports dynamically in
..NET.
See->http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnhcvs03/html/vs03g9.asp.
I'm not getting it to work. If I use the XML and XSL file as generated
by Access, it works OK, but if I generate the XML file myself and try
to transform that with the XSL file, I just end up with a...
|
by: JoeW |
last post by:
I'm utilizing a database that I created within MS Access within a
program I've created in VB.NET. I am using the VB front end to
navigate the information, but want to be able to print a report, that
I've also created within MS Access. I've attempted using the
Access.Application instance, but I get errors when it tries to load the
database. Just wondering if anyone has any experience with this, and
what I should do.
Thanks for any...
|
by: booner |
last post by:
Is there any way to show an existing access database (.mdb) report inside a
vb.net application?
Any/all pointers much appreciated.
BBB
|
by: NeoDeGenero |
last post by:
I have a little VBA/Access - Reports problem and I’m not sure on how to approach it:
I am trying to send a Report generated by MS Access via email through the command SendObject.
DoCmd.SendObject acSendReport, "Practitioners2", acFormatXLS, _
"George Liu; neo_skool@hotmail.com", "George Liu", , _
"SubjectLine", , False
I’m not sure exactly how to structure the whole VBA code to access the database, and searching around, there...
|
by: Qtip23 |
last post by:
Hello All,
So I have a my database information placed on a SharePoint site now that there is an immediate need for a web-based application in my division.
I am able to print Access Reports from SharePoint but this annoying non-breaking space mark --   -- keeps printing out as well.
Is there a way to handle or suppress that from occuring when printing out Access reports?
Thanks,
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
