Full Version: Automatically Saving a report with a record specific filename
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
Thrsher
In order to streamline a process I enquiring whether it is possible to do a couple of things:

When a report is generated from the current record on my form, is it possible to export it directly into MS Word and bypass the preview pane??

Secondly, if the above is possible can you direct it where to save the report and generate a file name based on the record e.g ACK LET [Branch Number] [todays date] and finally to save the file but keep the document open??

To summarise:

User runs the report, it exports it to MS Word, saves it in a specific location with a unique file name and the keep the document open to amend.

Any help is much appreciated.

Regards
JimCarney6
i think the outputto action will do what you want. you can also tell it to automatically launch the software of the program you are outputing to. you can output reports specifically. and you can probably change the name based on the record. i've never tried it with this action, but there is a naming section of the method and i think you could use a variable to build the file name string. i;ve just not specifically tried in this case.
in a sendobj i did it with something like this
"Endorsement Request " & strEndPN

where i had set strEndPN equal to the primary key of the record earlier.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.