Hello

I have generated a report based on a query and user input. Is it possible to lock the report and save it under a different name once the user is happy with the report.

I want to be able to reopen the saved report without having to run the query or the user input again.


Alfred67

You could publish it to Word and save it there.

In Access 2007 save it as a PDF.

Otherwise save a summary of the current data from the record source into a table against a ReportID and use that to recreate the report later.

In Access 2007 save it as a PDF..

I'm using access 2003.

Otherwise save a summary of the current data from the record source into a table against a ReportID and use that to recreate the report later.

I'm not sure how to do that

Alfred67

i think the best way is to open in preview mode, then right click, and export to one of the available formats.

snapshot, maybe up to A2003
pdf in A2007


or use a pdf convertor, and generate a pdf. needs a little bit of code

You could install cutepdf and print/save through that.