Publishing Report!!!! 2

[99mel]

Can anyone help me with this problem???<br>
<br>
I am wanting to publish a Report into Microsoft Word. As you do this with Access it creates a .rtf and displays the reports data only and not the lines or boxes or anything.<br>
If u were to publish a table to Word it also creates a .rtf file but imports a embedded Object of the table.<br>
<br>
The only way I can see of doing publishing a report into word with the boxes and lines of the report is to publish it using a .doc file? <br>
<br>
Is this possible???????<br>
<br>
Any help much appreciated!<br>
<br>
Thanks

 

[DougP]

I guess the question I have is why must you create a report in Word.<br>
And not just stay in Access.<br>
The most successful way I have used Word is creating a Mail merge.<br>
But anytime you have 2 Office program Talking to each other. You need a FAST machine with lots of RAM or it will bring things to a screaching halt.<br>
<br>
Then the fun begins when you corrupt an Access Database.<br>
<br>
You can with a little finesse create a report in Access that looks like any thing Word could make.<br>
I've done it.<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[99mel]

The reason why I am wanting to do this is because the Access database is about 30mb....All i'm wanting is the report to mail off to someone. This is why I am wanting to convert it into Word and that will probably come to a small 50K or something.

 

[DougP]

Well you can e-mail write out of Access.<br>
Create a query that narrows down your result.<br>
Then either create report that is connected to that query or just send the Query<br>
<br>
Use this command<br>
DoCmd.SendObject acSendQuery, &quot;MyQuery&quot;, acFormatRTF, &quot;<A HREF="mailto:99mel@yoursite.com">99mel@yoursite.com</A>&quot;, , , Subject, Body, False<br>
<br>
you can send these types of data<br>
<br>
objecttype One of the following intrinsic constants:<br>
acSendForm<br>
acSendModule<br>
acSendNoObject (default)<br>
acSendQuery<br>
acSendReport<br>
acSendTable<br>
objectname A string expression that's the valid name of an object of the type selected by the objecttype argument. If you want to include the active object in the mail message, specify the object's type with the objecttype argument and leave this argument blank. If you leave both the objecttype and objectname arguments blank (the default constant, acSendNoObject, is assumed for the objecttype argument), Microsoft Access sends a message to the electronic mail application without an included database object.<br>
If you run Visual Basic code containing the SendObject method in a library database, Microsoft Access looks for the object with this name first in the library database, then in the current database.<br>
<br>
In one of these formats<br>
outputformat One of the following intrinsic constants:<br>
acFormatHTML<br>
acFormatRTF<br>
acFormatTXT<br>
acFormatXLS<br>
<br>
Look up SendObject in Help for all the details<br>
This works fantastic I use it everywhere.<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[MichaelJ]

Another approach is to export the report to the Access Snapshot Viewer file format. The Microsoft Snapshot Viewer enables you to view a report snapshot without having Microsoft Access 97 or Microsoft Access 2000 or the run-time version of Microsoft Access 97 or Access 2000 on your computer. It also keeps all of your graphics intact exactly as they appear in an Access report. You can download the viewer from Microsoft at the following site.<br>
<br>
<A HREF="

http://www.microsoft.com/downloads/release.asp?ReleaseID=12669"

TARGET="_new">

http://www.microsoft.com/downloads/release.asp?ReleaseID=12669</A><br>

<br>
Mike

 

[99mel]

I have d/l this snapshot program but can't seem to export the report to the snp format.<br>
If i go to Export on the file menu there is no snapshot extension. I've used the text file extensions and replaced the extension with .snp<br>
When i open the file it comes up with an error 'An error occured while opening the file'<br>
<br>
Any ideas

 

[famousb]

A last idea that is succesful for me for a similar situation is to print to Acrobat PDFWriter (which is contigent on you having Adobe Acrobat writer of course, a small version is relatively cheap these days). This will create a doument that is easily readable by anyone, and also easily published on the web (Acrobat reader is freeware). The downside is that they can't edit the document, if you want them to be able to do that (otherwise it is another upside). <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[Dumboy]

Call me crazy...... but can he go to other way? instead of sending the information to Access into word can he request the report from a word template that feeds from his Access database so he can preformat the document....<br>
<br>
My mom told me not to smoke this... but.....<br>
<br>
Hey if this was just another of my stupid suggestions please do not hesitate in insulting me in any way you can.... <br>
<br>
as and added note.... sometimes we focus so hard in doing something in a certain way that we really forget what are we trying to accomplish..... what was that..... I don't really know it just came out of my fingers...... oh! my god I'm possessed........!!!<br>
<br>
....arghhh.....! OUCH.....! <p>Dumboy.! Ouch.! .my brain.....<br><a href=mailto:spiderdesign@yahoo.com>spiderdesign@yahoo.com</a><br><a href= > </a><br>It's hard to think with only one neuron......Ouch.....!....it hurts when I think......!

 

[MichaelJ]

The file extension only shows up when you have the report open. Then go to File¦Save As/Export¦then select the option to an external file or database and click OK. Scroll to the bottom of the save as type dropdown box and you should see the Snapshot Format(*.snp)option.<br>
<br>
Also you can do this with a Macro when you use the Output To Method and use a report as the object type. In the output format selection a drop down arrow appears and the snapshot format is available. <br>
<br>
Mike<br>

 

[Freckles]

99 mel
I have a multi page report that I need to send to Word. Did you get your Snapshot to Word &quot;opportunity&quot; handled? : Deb Koplen
deb.koplen@verizon.com

A person can stand almost anything except a succession of ordinary days.