Reply
 
Thread Tools Display Modes
  #1   Report Post  
Ralph
 
Posts: n/a
Default Capture 'printed output' from Access to inset into Word as Exhibit

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!
  #2   Report Post  
CyberTaz
 
Posts: n/a
Default

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 FileExport 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 |:)

"Ralph" wrote:

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!

  #3   Report Post  
Ralph
 
Posts: n/a
Default

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!!

"CyberTaz" wrote:

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 FileExport 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 |:)

"Ralph" wrote:

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!

  #4   Report Post  
CyberTaz
 
Posts: n/a
Default

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 ToolsStartup & 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 ToolsOffice 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 |:)

"Ralph" wrote:

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!!

"CyberTaz" wrote:

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 FileExport 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 |:)

"Ralph" wrote:

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!

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I access Word Help file without having to insert a CD ever. Anna Summers Microsoft Word Help 4 June 29th 05 05:39 PM
Word 97 opening Access 2000 RS200Phil Mailmerge 2 January 31st 05 02:54 PM
exporting accress reports into word marc Microsoft Word Help 8 December 29th 04 04:40 PM
Word mail merge with Access Linda Mailmerge 1 December 7th 04 11:46 PM


All times are GMT +1. The time now is 03:42 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"