Export report/subreport to Word

  • Thread starter Thread starter Dee
  • Start date Start date
D

Dee

Good Morning,

We do our quotes in access and they have subreports which contain the line
items. My boss would like to get the line items on the subreport when they
export to Word to be in a table instead of the tab format in which they get
exported right now. I have read about exporting into a template, but have
not had time to play with that idea. Is there a way to export to Word and
have the subreport come out in a table format instead of tabs?

If you need more info, please advise.

Thanks,

Dee
 
There is a great piece of code written a couple or so years ago by Ken Getz,
called: CreateTableFromRecordset, designed to take a recordset and turn it
into a table in a Word doc or dot file. (You can find it in his Access 2000
Developers Handbook (and later versions)). You may also find all of the
code for it by doing a search at: http://groups.google.com searching on:
CreateTableFromRecordset

I do not know if using this code will fit into your current process or not;
however, I have used it for some time with Automation to fill a Word
template, using Word Bookmarks to write specific data from a form, and a
last Word Bookmark to denote where the Word Table will be built. You might
want to have a look at this code and keep it for future reference.
 
Thank you Cheryl, I actually have the Access 2000 Developer's Handbook. I
will have to look that up. Thanks for your help... we'll see if I get lost!

Have a great day!

Dee
 
Back
Top