How to save a report in Access Database?

[Lilyli]

Hello everybody,

The following is my question:

At present, the report can only be obtained in hard copy. How to save the report in electronic form so that there is a choice of printing or included in other application (Email, other report etc)?

Thanks for your help in advance!

 

[xlbo]

More info needed - how is the report generated ?? where is it coming from ?? is it from an internal or external source ?? By "hardcopy" do you mean you recieve it hardcopy or you can only print it off ??

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[Lilyli]

Sorry I did not state it clearly. We have a project developed using Access 97, the report is from internal source. Right now, when user click "print" button in a form, the report will be printed immediately.

Thanks.

 

[xlbo]

Well if you have a report in Access 97 then it is already included in the database - it should be accessible already

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[infinitelo]

There are a couple of options here. one is to set up a printer that writes to a file. if the report has a lot of graphics pdf printer software is the ticket. One consideration is that once you save the report to a file, inevetable someone will need information from the report to go into further processing. at which point you will best be served by haveing the report printed to a generic printer set to file. then you can open the report with you favorite tool and give results as needed.

Im not sure on your version of access but xp and later have the option to send reports to html.

if it is to be it's up to me

 

[PHV]

Take a look at the DoCmd.OutputTo method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[GummowN]

A wild stab in the dark here - but I take it the report changes on a day to day basis and you want to save the instance of that report. There are 2 ways of doing this:

Print the report as a pdf, saving the result to a structured filename

Have it so that the report can be regenerated for any date.

The latter is more efficient, but you really need to give more information about the report, what you are capable of doing within the database and what you are trying to achieve.

If at first you don't succeed, try

http://www.tek-tips.com

for the answer.