Solved

export report from accdr to snapshot viewer

Posted on 2008-11-02
3
645 Views
Last Modified: 2013-11-28
how do the final user can export the access 2007 report to excel or snapshot viewer from the run-time version (accdr)?
0
Comment
Question by:nuritat
3 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 125 total points
ID: 22860846
nuritat,

Well you can no longer export Reports to Excel in Access 2007.

To export to a snapshot:
Drop a combobox on the form that just lists Reports from the MsysObjects Table.
Then use code like this to export the file to the folder of your choice:

        DoCmd.OutputTo acOutputReport, Me.Combo3.Column(1), acFormatSNP, "C:\YourFolder\" & Me.Combo3.Column(1) & ".snp"


Here is a sample

JeffCoachman


Access-EEQ23868517SnapshotReport.mdb
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question