Capture 'printed output' from Access to inset into Word as Exhibit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a number of Access applications which print directly to a printer. I'd
like to capture this print (or at least a page) and 'Insert' it into a Word
document as an Exhibit, in a training manual. PS I do not have access to the
definition of the Report in the Access application!
 
Hi Ralph-

The report does not need to be modified, so you don't need access to its
design (definition) if you are using Access 2000 or later.

In the report's Preview window toolbar there is an Office Links button on
which you can click the right edge (small black triangle) and choose Publish
It to MS Word. This will give you an .rtf file with all the report's
formatted content, but will not contain any graphics (lines, rectangles, etc.
as well as pictures).

If you want a 'carbon copy' complete with graphics (but uneditable), you
could instead go to File>Export and choose Snapshot Format (*.snp) from the
File Type list. The .snp file can be printed separately or inserted in a Word
doc as an embedded Object.

Other options are available as well.

HTH |:>)
 
In this case the Access application is a packaged one which does not provide
access to the normal "Access" screens. All of the navigation through the
application is accomplished through author defined menus. The reports are
likewise generated through menus. One simply clicks on the report desired
(button on the menu) and then clicks on a button entitled "Print Selected
Report" There is no File > Print Preview > capability.

I have tried printing to a printer defined as "print to a file" and can get
a file of .prn type but I can't find any way to interpert it of save it as a
..rtf file. What am I doing wrong? Response was good but did not quite fit the
situation. Thanks!!
 
Hi Ralph-

Sorry for delay, but if you are dealing with a custom DB app your options
are going to be limited.

Is the Access Databse Window available to you? (It gives the listings of
Tables, Forms, Reports & other objects in the file.) It may be minimized or
hidden when you launch the file. If you can't seem to get to it, press the
F11 Function Key. That will open it for you if the keystroke hasn't been
disabled. Or, if the Window Menu is available, see if the UnHide command is
active. As a last resort, go to Tools>Startup & check the box for Display
Database Window if you can.

If you can get to the DB Window, you need only click the report to select
it. Then you can use the Office Links button if it is on the Access toolbar.
If not, got to Tools>Office Links and choose 'Publish It with MS Word' from
there.

In the DB Window you can also rt+click the report name & choose Export in
order to output it as a .snp, or select the report & use the Export command
from there. You may also have a Send To command that you can use to email a
copy to yourself.

The key ingredient is getting to the Database Window. If you need to post
back, try to include which version of Access is involved.

Good Luck |:>)
 
Back
Top