[AccessD] [dba-OT] Output report to word

Rocky Smolin rockysmolin at bchacc.com
Sat Mar 12 14:31:26 CST 2016


That will be my next approach of the client doesn't buy off on an rtf
format.  It looks like with Charlotte's tip about using underscore to create
a rule, it might pass muster.

Thx.

r 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
John Bodin
Sent: Saturday, March 12, 2016 12:23 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] [dba-OT] Output report to word

Rocky, as an alternative, can you figure out all the fields you will need,
create a table in a 2003 MDB with those fields in it and use that as your
merge source for the Word Doc?  Then when person runs the report, you would
dump the data into the table and just call Word and not worry about the book
mark piece.  Not sure what your data looks like as far as what query(ies)
you need so that might be harder, but I've used both ways depending on the
requirement of the app.

John

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Rocky Smolin
Sent: Saturday, March 12, 2016 3:05 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] [dba-OT] Output report to word

Yes.  That's the mail merge approach - make a .dot document with the
bookmarks and populate from an Access BE using automation.

I've done it.  It's a PITA.  So just looking for an easy way out.

r
 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Paul Hartland
Sent: Saturday, March 12, 2016 11:09 AM
To: Access List
Subject: Re: [AccessD] [dba-OT] Output report to word

Is it possible to create a word template with fields, then just write the
data across, im in pub at moment but would be abke to help more tomorrow On
12 Mar 2016 18:57, "Charlotte Foust" <charlotte.foust at gmail.com> wrote:

> I seem to recall using underscores to create lines that were 
> exportable to rtf.  The line controls don't export.
>
> Charlotte Foust
> (916) 206-4336
> On Mar 12, 2016 9:01 AM, "Rocky Smolin" <rockysmolin at bchacc.com> wrote:
>
> > BTW - this is Access 2003.
> >
> > r
> >
> > -----Original Message-----
> > From: dba-OT [mailto:dba-ot-bounces at databaseadvisors.com] On Behalf 
> > Of Rocky Smolin
> > Sent: Saturday, March 12, 2016 8:39 AM
> > To: 'Access Developers discussion and problem solving'
> > Cc: 'Off Topic'
> > Subject: [dba-OT] Output report to word
> >
> > Dear List:
> >
> > I need to output a couple of reports to a word doc. If I can avoid 
> > the template/bookmark thing that would be great.
> >
> > DoCmd.OutputTo acOutputReport works well, but the reports have line 
> > and boxes which I would like to preserve.  OutputTo has a formatting 
> > option
> of
> > acFormatRTF which outputs all the text correctly formatted and 
> > spaced in Rich Text Format but loses the lines and boxes.
> >
> > Is there a simple way to create a word doc from a report that will
> preserve
> > lines, boxes and images (would like to have the client's logo in the 
> > Word doc)?
> >
> > MTIA
> >
> > Rocky Smolin
> > Beach Access Software
> > 858-771-1869
> > www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com 
> > <http://www.e-z-mrp.com/>
> > Skype: rocky.smolin
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list