Grids in report to be printed in Words

  • Thread starter Thread starter Jan Il
  • Start date Start date
J

Jan Il

Hi all - Access 2002, WinME

I need to be able to create a copy of a report for both e-mailing and
printing from MS Word (2K). I have the controls outlined with gray borders
to define the spacing, and when printed from Access these grids show up
fine. But, when I take it into Word to print or save the report as a Word
doc, the borders do not show up.

Is there some way that I can get the borders to carry over to Word to define
the spacing there as well? This is my first experiment with this, but,
Accounting does not have Access, so they can't access the information from
the database. They want a Word copy of the report, thus, I have to carry the
report data into Word and create a copy to send to them. The Help so far has
been a bit vague on this area, how to get it into Word, but, information
about borders is somewhat elusive.

Any suggestions or related information would be very much appreciated.
Perhaps someone has had this experience and found a way to work it out.

Best regards,
Jan :)
 
Yes, the translation from Access report to Rich Text File does not include
the graphics elements. I do not know of a way around this, other than to
control Word through automation and generate the Word document from code in
the Report's events instead of saving the Report itself.

But, if anyone is likely to have a workaround, it would be MVP Stephen
Lebans, http://www.lebans.com. You might take a look there.

Larry Linson
Microsoft Acces MVP
 
Hi Larry!

Larry Linson said:
Yes, the translation from Access report to Rich Text File does not include
the graphics elements. I do not know of a way around this, other than to
control Word through automation and generate the Word document from code in
the Report's events instead of saving the Report itself.

But, if anyone is likely to have a workaround, it would be MVP Stephen
Lebans, http://www.lebans.com. You might take a look there.
Click to expand...

Thank you very much for your time to reply, and the information for
Stephen's website. I'll pop in and see if he was some sort of workable
solution in his very impressive magic bag of tricks. <g>

Happy New Year!
Jan :)
 
Jan,

Ken Getz and his co-authors wrote a function named
"CreateTableFromRecordset" for their "Access xx.x Developer's Handbook"
editions. It is used with Word Automation to create a Word table in a
template from row/column Access data. Works great and provides a great
looking report, even allowing you to select the style of Word table you want
to produce.

The code is copyrighted, so I won't reproduce it here. You might want to
check the Developer's Handbook website
http://www.developershandbook.com/downloads.htm to see if it is available
via download or search http://groups.google.com using the function name as a
criterion to see if it's available anywhere else.
 
Hi Cheryl!

Cheryl Fischer said:
Jan,

Ken Getz and his co-authors wrote a function named
"CreateTableFromRecordset" for their "Access xx.x Developer's Handbook"
editions. It is used with Word Automation to create a Word table in a
template from row/column Access data. Works great and provides a great
looking report, even allowing you to select the style of Word table you want
to produce.

The code is copyrighted, so I won't reproduce it here. You might want to
check the Developer's Handbook website
http://www.developershandbook.com/downloads.htm to see if it is available
via download or search http://groups.google.com using the function name as a
criterion to see if it's available anywhere else.
Click to expand...

Thank you very much for this reference! I recently purchased the 2002
edition of the Ken Getz and associates Developer's Handbook Set by Sybex
after I got Office 2002 XP. I looked there and in the 2 associated CD
examples, but, I guess I was not thinking in the right terminology or
context of wording to find anything. There is such a volume of information
that, like many of the Help files, if you don't know exactly how to word
your search, or know exactly how it may be listed, it is sometimes hard to
find. Since I was looking for something related to linking a report to Word,
or transfer of report format to Word, etc., I would not have paid attention
to the "CreateTableFromRecordset" function. The 'ol Eye-Word-Brain
association thingie I guess. <g>

I'll certainly look this up in my books and see if they have an example on
the CD's and give it a try. I truly appreciate your time to provide this
reference.

Happy New Year!
Jan :)
 
As it happens, I have the handbook right here by my computer. The function
is found on pages 826-827 of the first volume, Desktop Developer's Handbook.
 
As it happens, I have the handbook right here by my computer. The
function
is found on pages 826-827 of the first volume, Desktop Developer's
Click to expand...
Handbook.

Got it! Too kewl! I'll start back on pg. 821 Example: Word As a Report
Writer, and go through the whole wazoolie on that part. Hopefully, there's
also a example on the related Desktop CD. Although, the code and all looks
really pretty simple. (NOT!!!!....gulp..) <bg>

Thanks so much for the additional reference information, Cheryl, I really do
appreciate it. Now...I'm off to the abyss.... :-)

Jan :)
 
I found the only way to keep the grid lines was to export
as a snapshot (.snp). If other people want to view a .snp
they will need to have Snapshot installed on their
computers. MS XP comes with Snapshot.

I did find a plugin that you can purchase that will allow
you to export as a word file. I found it here:
http://www.4tops.com/microsoftaccessdownload.htm

I am not sure if it works.
 
Back
Top