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

[Stuart McLachlan]

Yes, that's how I build them, 'cos  I'm not a Word Object Model guru by any stretch of the 
imagination :)

Just make sure that you fully qualify ALL references to avoid the dreaded "unqualified 
reference problem".

Haven't mentioned that one for a while, so as a refresher, or for those who are not aware of it 

https://support.microsoft.com/en-us/kb/189618

https://support.microsoft.com/en-us/kb/319832




On 12 Mar 2016 at 15:52, Rocky Smolin wrote:

> Beautiful.  I'll use that if the rtf approach doesn't work.
> 
> Does Word have a macro recorder like excel (which is how I always
> automate excel from access) that could show me code for these things?
> 
> r
> 
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> Of Stuart McLachlan Sent: Saturday, March 12, 2016 2:54 PM To: Access
> Developers discussion and problem solving Subject: Re: [AccessD]
> [dba-OT] Output report to word
> 
> Here's a code snippet that outputs a variable set of records to a Word
> document. The  document contains an appropriately formatted table with
> one row. The Boookmark is in the first column of that row. (Actually
> there is only one column in this example).
> 
> objWord.Selection.GoTo What:=wdGoToBookmark, Name:="Essential"
>  While Not rs.EOF
>       objWord.Selection.TypeText Text:=rs!COmpetency & vbCrLf
>       objWord.Selection.InsertRowsBelow 1
>       rs.MoveNext
> Wend
> objWord.Selection.Rows.Delete
> 
> The vbCRLF moves the cursor to the next fcolumn in the table, if you
> have more than one - so you don't need to set up multiple bookmarks -
> just one in the first column of the initial single row.'
> 
> 
> On 12 Mar 2016 at 12:06, Rocky Smolin wrote:
> 
> > If I do this as a report it will have a couple sub-reports with
> > varying record counts.
> > 
> > If I set up say four bookmarks across the page and push four values
> > from different fields into them and then push four more, will it
> > make a second line?
> > 
> > r
> > 
> > -----Original Message-----
> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On
> > Behalf Of Susan Harkins Sent: Saturday, March 12, 2016 11:15 AM To:
> > 'Access Developers discussion and problem solving' Subject: Re:
> > [AccessD] [dba-OT] Output report to word
> > 
> > Rocky I was going to suggest the same thing. It might be your best
> > bet -- time-consuming initially, but changes to the Word template
> > would be much simpler than reworking your Access report workaround.
> > And, you know they'll want changes. :)
> > 
> > Susan H. 
> > 
> > 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:
> > 
> > 
> > 
> > --
> > 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
>