relationship report to word 
Author Message
 relationship report to word

I am in the process of documenting a large access database that I
created.  In a section of the manual I describe how all the
relationships between the tables work.  I have printed out the
relationship report and inserted it by hand into the document.  I
replace a page, so the table of contents still works.  This works, but
it is not very satisfactory.  I would like the word document to be self
contained.  I tried scanning the printed report and including the
graphic in the document.  The resolution is not great and it make the
word file very large.  Also whenever I change the relationships, this
creates a lot of work to update the documentation.

I tried the export function from the report preview and it didn't work.
I tried rich text, and Excel 2000, but the files that created were
almost entirely blank.  It did not show the relationships.

Is there a way to get the graphic definition of the relationships into
word.  If you know how, please help.

Thanks.

--
If you have kids, please visit my website:
http://www.*-*-*.com/



Tue, 25 Nov 2003 07:05:40 GMT  
 relationship report to word
Just what the doctor ordered.<grin>
http://www.lebans.com/windowtobitmap.htm
WindowToBitmap is a database containing a class to allow you to capture
and save the entire contents of the Relationships window to a disk based
Bitmap file. This is roughly a 4800 x 4800 pixel window. The Bitmap is
saved as a 16 color BMP in order to reduce file size.

Eric load the resultant Bitmap file into a Paint program and save it out
as a Gif file. It will be very small at that point.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


Quote:
> I am in the process of documenting a large access database that I
> created.  In a section of the manual I describe how all the
> relationships between the tables work.  I have printed out the
> relationship report and inserted it by hand into the document.  I
> replace a page, so the table of contents still works.  This works, but
> it is not very satisfactory.  I would like the word document to be
self
> contained.  I tried scanning the printed report and including the
> graphic in the document.  The resolution is not great and it make the
> word file very large.  Also whenever I change the relationships, this
> creates a lot of work to update the documentation.

> I tried the export function from the report preview and it didn't
work.
> I tried rich text, and Excel 2000, but the files that created were
> almost entirely blank.  It did not show the relationships.

> Is there a way to get the graphic definition of the relationships into
> word.  If you know how, please help.

> Thanks.

> --
> If you have kids, please visit my website:
> http://www.id-inside.com



Tue, 25 Nov 2003 09:28:28 GMT  
 relationship report to word
Stephen, has anyone commented recently on your wonderfulness?

--

Dirk Goldgar
www.datagnostics.com
(to reply via email, remove NOSPAM from address)


Quote:
>Just what the doctor ordered.<grin>
>http://www.lebans.com/windowtobitmap.htm
>WindowToBitmap is a database containing a class to allow you to capture
>and save the entire contents of the Relationships window to a disk based
>Bitmap file. This is roughly a 4800 x 4800 pixel window. The Bitmap is
>saved as a 16 color BMP in order to reduce file size.

>Eric load the resultant Bitmap file into a Paint program and save it out
>as a Gif file. It will be very small at that point.
>--

>HTH
>Stephen Lebans
>http://www.lebans.com
>Access Code, Tips and Tricks
>Please respond only to the newsgroups so everyone can benefit.



Tue, 25 Nov 2003 22:26:30 GMT  
 relationship report to word
Everyone except my wife!<grin>
:-)

Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


Quote:
> Stephen, has anyone commented recently on your wonderfulness?

> --

> Dirk Goldgar
> www.datagnostics.com
> (to reply via email, remove NOSPAM from address)



> >Just what the doctor ordered.<grin>
> >http://www.lebans.com/windowtobitmap.htm
> >WindowToBitmap is a database containing a class to allow you to
capture
> >and save the entire contents of the Relationships window to a disk
based
> >Bitmap file. This is roughly a 4800 x 4800 pixel window. The Bitmap
is
> >saved as a 16 color BMP in order to reduce file size.

> >Eric load the resultant Bitmap file into a Paint program and save it
out
> >as a Gif file. It will be very small at that point.
> >--

> >HTH
> >Stephen Lebans
> >http://www.lebans.com
> >Access Code, Tips and Tricks
> >Please respond only to the newsgroups so everyone can benefit.



Tue, 25 Nov 2003 23:18:44 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Crystal Reports: Help required in defining one-to-many relationship on db schema

2. Help with one-to-many relationship report format...

3. Reports, reports, reports, reports.....REPORTS!

4. Print word doc based on report field

5. filterd report wit pictures into word

6. Print Form or report In Word

7. Report in Access to Word....

8. Filter for report and outputting to Word

9. Linking an existing Word docs into Access reports

10. Access report convert to word doc

11. Duplex Word doc with Access Report from Access

12. exporting a report from Access97 to Word

 

 
Powered by phpBB® Forum Software