473,695 Members | 2,248 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Export Access Report (multiple pages) into Powerpoint

I have read postings on the similar subject including the posting from
2003 shown below. This process works fine to display a single page
snapshot report in PowerPoint. I need to display subsequent pages from
the same snapshot file in subsequent slides in PowerPoint. I realize
that it is possible to add VB code to the Snapshot Viewer Control and
that there are properties such as .FirstPage, .NextPage, .LastPage,
etc, But I can't find any examples of actual code to write to move to
a subsequent page in the Snapshot file.

Thanks for your help!

From: evilhanz - view profile
Date: Wed, Jul 9 2003 12:13 pm
Email: evilh...@hotmai l.com (evilhanz)

To add an Access report to PowerPoint:

1. In Access, open your report. Choose "File Export" from the menu

to export your Access report as a Snapshot File.

2. In Powerpoint, insert a Snapshot Viewer ActiveX Control into the
slide from the Control Toolbox by clicking the "More Controls"
button
and selecting it from the list.

3. After the control has been inserted, right-click on the control
and
select "Snapshot Viewer Control Object Properties".

4. Click the "Browse" button to locate the report you saved in SNP
format. Beware: An absolute path is stored rather than a relative
path. If you move the presentation or the report, the link will be
broken unless you update it in code.

5. Save your presentation and view it.

That's all there is to it.

Sep 5 '06 #1
1 22771
I used ellenh's instructions:
1. In Access, open your report. Choose "File Export " from the menuto export your Access report as a Snapshot File.
2. In PowerPoint, insert a Snapshot Viewer ActiveX Control into theslide from the Control Toolbox by clicking the "More Controls" button and selecting it from the list.
3. After the control has been inserted, right-click on the control andselect "Snapshot Viewer Control Object Properties".
4. Click the "Browse" button to locate the report you saved in SNP format.
Beware: An absolute path is stored rather than a relative path. If you move the presentation or the report, the link will be broken unless youupdate it in code.
5. Save your presentation and view it.
Comment about creating the Snapshot file: For a report in portrait layout, I used a top margin of .5 inches and a bottom margin of 5.5inches. Otherwise, the Snapshot file page length is too long to fit onthe landscape format of a PowerPoint slide.
For subsequent pages in the same Snapshot file, duplicate the existing Powerpoint slide that now shows the first Snapshot file page.
Right click on the Snapshot Viewer object and select Properties.Chan ge the value in the Current Page property from 1 to 2.
Repeat as needed for subsequent pages.
That's it! Simple!
But when I presented it to the users -- At first, they would not mind
to do it manually if the Snapshot contains less than 10 pages -- But
the true fact was that, our exported Snapshot file would rarely have
less than 10 pages (each page is ONE PowerPoint Slide) -- It will take
a lot of time to do it manually if the Snapshot file may contain from
50-200 pages of reports -- Therefore, I have to find a solution in VBA
Code that would be able to break each SnapShot page into PowerPoint
Slides automatically.

Additionally, my users wanted me to create a command button on the data
entry form that after entering the data of a new record -- They would
click on that command button and the data would automatic add into the
existed PowerPoint slides file... and so on --

Any suggestions or VBA codes would be truly appreciated very much.

Sep 6 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2010
by: Fred | last post by:
I have a database of stores in Access and am trying to get the information as a page on my website. I have designed a report that gives the information in the way I want but when I export the report as html it breaks it apart at letter size intervals into separate pages. 1/ How do I get the report to scroll contiuously so it ends up as one continuous datatable html file? 2/ Is there anyway to insert html in the report and have it...
2
8127
by: Vikrant | last post by:
Hey Friends I need to export an Access Report using a filter. I am using the method OutputTo m_pDoCmd->OutputTo( 3, // asOutputReport COleVariant(strReportName), // <report name> COleVariant(_T("HTML (*.html)")), // acFormatHTML
2
4898
by: Yisroel Markov | last post by:
Greetings, two of my users have the same front end db (A2K). Each of them has created, in addition to the standard reports, a personal customized report. Now they both want to be able to run both reports. Is there a way I can export a report definition - not the report and not the data - from one user to another, or do I have to manually re-create for each guy the other guy's custom report? I know you can do it in Crystal Reports and...
0
5379
by: ghadley_00 | last post by:
MS Access Create form / report with multiple pages using different background images Hi, Would like to have users fill out a multipage form, and then click a print button, which pulls up the info just entered for a particular record and print out multiple pages of forms, each page having a different image as background.
1
8055
by: Vincel2k2 | last post by:
Hi, I need to provide Access reports from our web site. When the app gets to the output command I get this error I get this error: The formats that enable you to output data as a Microsoft Excel, rich-text format, MS-DOS text, or HTML file are missing from the Windows Registry. Also after the snapshot is created how do I get it to the users web page? Thanks Here is my code: Private Sub Button1_Click(ByVal sender As System.Object, ByVal...
1
2058
by: smitchcoff | last post by:
Hi, I've got a report in Access 2000 that pulls data from a temporary table. The report runs just fine but when I try to print the report, the print dialog pops up and sends "something" to the printer, but nothing ever prints. I have tried multiple computers from multiple machines all with the same result. There is nothing holding up the printer queue. When I export the report, I get the values from the table. There are multiple reports...
1
10877
by: Bob Alston | last post by:
Anyt one know a way to correctly export an Access 2003 report to Excel? I can use Tools - Office Links ..... just fine with a query or table. But when I try a report it just doesn't work. right now my workaround is to export via Office Links to Word and then cut and paste into Excel. I am hoping for a more "idiot proof" method Bob
10
24409
by: ConnollyS | last post by:
Is it possible to export a report from Access to Excel and keep all the formmating. i.e. Lines, boxes etc... Or do you need to create an excel template and then use a macro or some VB code to run an access query to generate the excel sheet with the pre-defined formatting? Thanks in advance.
0
2317
by: Sohail1980 | last post by:
Hi All, I have a crystal report that loads default values from the database, using SQL server 2005. On my web page, I have 2 databound dropdownlist and upon selectedindexchanged the report must reload data based on selectedindex. However only the first page of the report refreshes while the other pages remain with the initial data. When I try to export the report to excel using the export button from the crystalreportviewer toolbar it...
0
8635
marktang
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...
0
8574
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9119
Oralloy
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...
1
8852
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,...
1
6493
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5839
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();...
0
4342
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
2276
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1977
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.