Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I access Word Help file without having to insert a CD ever. | Microsoft Word Help | |||
Word 97 opening Access 2000 | Mailmerge | |||
exporting accress reports into word | Microsoft Word Help | |||
Word mail merge with Access | Mailmerge |