Exporting a Report As a Word Document - Microsoft Access / VBA

feck

Hi,
Is there any code/routine to export a report as a word
document retaining the formatting. I have a requirment to produce
some fairly detailed statisitical reports for transmission by e-mail.
The reports require tweaking on a regular basis so I do not really
want to base a standard document on query data, but would prefer to
redesign the report as required and export that on completion. I know
I can save as rtf etc. but you lose all of the formatting which rather
defeats the object of producing a detailed and coherent report ?

Thanks

JBN

Nov 13 '05 #1

Subscribe Reply

3073

Greg in Detroit

You can export an Access report as a Snapshot file (.snp). This retains all
formatting.
Everybody with Office XP and above has the Snapshot Viewer needed to view
the file.
If you don't have the viewer, it can be downloaded free from Microsoft.
The Snapshot Viewer allows the recipient to view and print, but not edit the
report.

Regards, Greg in Detroit

"feck" <ne*********@hotmail.com> wrote in message
news:8v********************************@4ax.com...

Hi,
Is there any code/routine to export a report as a word
document retaining the formatting. I have a requirment to produce
some fairly detailed statisitical reports for transmission by e-mail.
The reports require tweaking on a regular basis so I do not really
want to base a standard document on query data, but would prefer to
redesign the report as required and export that on completion. I know
I can save as rtf etc. but you lose all of the formatting which rather
defeats the object of producing a detailed and coherent report ?

Thanks

JBN

Nov 13 '05 #2

feck

On Sat, 12 Feb 2005 16:26:04 GMT, "Greg in Detroit"
<re**************@yahoo.com> wrote:

Thanks for info Greg, unfortunately our organisation is not XP'ed up
at this time so would not be a solution at this time.
JBN

You can export an Access report as a Snapshot file (.snp). This retains all
formatting.
Everybody with Office XP and above has the Snapshot Viewer needed to view
the file.
If you don't have the viewer, it can be downloaded free from Microsoft.
The Snapshot Viewer allows the recipient to view and print, but not edit the
report.

Regards, Greg in Detroit

"feck" <ne*********@hotmail.com> wrote in message
news:8v********************************@4ax.com.. .
Hi,
Is there any code/routine to export a report as a word
document retaining the formatting. I have a requirment to produce
some fairly detailed statisitical reports for transmission by e-mail.
The reports require tweaking on a regular basis so I do not really
want to base a standard document on query data, but would prefer to
redesign the report as required and export that on completion. I know
I can save as rtf etc. but you lose all of the formatting which rather
defeats the object of producing a detailed and coherent report ?

Thanks

JBN

Nov 13 '05 #3

altacct

Stephen Lebans has a a utility to output to an rtf that retains all the
formating. Unfortunately (though hugely impressively) it's all done
with images. This makes it look great on screen and when printed but
just about impossible to edit. You can check that out at
http://www.lebans.com/ReportUtilities.htm.

Jeremy Wallace

Nov 13 '05 #4

PC Datasheet

Your options are export to a Word template and tweak when necessary or save
the report as a PDF document and email the PDF document.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"feck" <ne*********@hotmail.com> wrote in message
news:8v********************************@4ax.com...

Hi,
Is there any code/routine to export a report as a word
document retaining the formatting. I have a requirment to produce
some fairly detailed statisitical reports for transmission by e-mail.
The reports require tweaking on a regular basis so I do not really
want to base a standard document on query data, but would prefer to
redesign the report as required and export that on completion. I know
I can save as rtf etc. but you lose all of the formatting which rather
defeats the object of producing a detailed and coherent report ?

Thanks

JBN

Nov 13 '05 #5

GaryB

You could export to RTF and then run a macro within Word to replace the
different fonts you've chosen in the report into Word Styles.

Rgds

GaryB

Nov 13 '05 #6

Similar topics

5520

Exporting to Word and including graphics

by: Jayjay | last post by:

Is it possible to export a report to word and have it include the graphics that are in the report? I'd like to take some of our reports and export them to word so we can email those to the...

Microsoft Access / VBA

1834

Exporting Reports to RTF format causes unexpected truncation

by: Stephan Golux | last post by:

Hello. I am using an access 97 application that exports a report to RTF format, which is subsequently emailed to various people. The main informational field in the report is a free form memo...

Microsoft Access / VBA

3321

I need help from VB/VBS experts: exporting Access OLE object (Word document) to a file

by: Otis Hunter | last post by:

I have been fighting with this for days and your expert help is needed! Below is the code I am executing which results with "Object doesn't support this property or method". The error is occuring...

Microsoft Access / VBA

3038

Exporting Report To MS Word

by: mik18 | last post by:

I'm having trouble with exporting reports to Word in the rtf format and I'm hoping someone has a solution. The reports are losing their formats. Not all the formating is lost but some is and of...

Microsoft Access / VBA

1711

Exporting to Word.

by: gooberoot | last post by:

Hi, When exporting a report to Word - all the formatting is exported with no problems, with ONE exception. Check boxes that show up in the reports are missing. When exported to Word, I don't...

Microsoft Access / VBA

3146

CrystalReport.NET exporting to Excel Problem

by: Mustufa Baig | last post by:

I have an ASP.NET website where I am showing off crystal reports to users by exporting them to pdf format. Following is the code: ---------------- 1 Private Sub ExportReport() 2 Dim oStream...

ASP.NET

3135

Programmatically exporting drill down crystal reports in .net fails

by: adamz5 | last post by:

I am currently exporting a crystal report using code. This works fine and exports the report to a word document onto disk using DiskFileDestinationOptions() and ExportOptions However when i...

Visual Basic .NET

2851

Problem with Exporting Data to Word

by: Mux | last post by:

I am facing the following problem while exporting data to Word. The current implementation is as described below: I have a JSP file which has a link that enables you to export the data to Word....

Javascript

4414

Exporting a Report to a Word Document

by: Bhujanga | last post by:

I need to create word documents from an Access Report. Below is the code that I am using. It works but there are problems. The page breaks generated by the report don't always line up just right with...

Microsoft Access / VBA

7251

What is ONU?

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,...

General

7367

Problem With Comparison Operator <=> in G++

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,...

C / C++

7089

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

5673

AI Job Threat for Devs

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,...

Career Advice

3230

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

3217

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1581

transfer the data from one system to another through ip address

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 ...

C# / C Sharp

790

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

451

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General