Prevent saving a report

[Phil Stanton]

In code I am opening a report in deign view, adding code to the report to
output it to Word in an editable form. I then want t close the report but
not save the changes.
Is there any way or preventing the option to save changes from being
displayed (the answer is always no)

The "DoCmd.Clos e acReport, me.Name, acSaveNo" on the close event does not
work

TIA

Phil

[Bruno Campanini]

"Phil Stanton" <di********@sta ntonfamily.co.u k> wrote in message
news:41******** *************@m ercury.nildram. net...

In code I am opening a report in deign view, adding code to the report to
output it to Word in an editable form. I then want t close the report but
not save the changes.
Is there any way or preventing the option to save changes from being
displayed (the answer is always no)

The "DoCmd.Clos e acReport, me.Name, acSaveNo" on the close event does not
work

TIA

Phil

Put
DoCmd.Close acReport, ReportName, acSaveNo
in your code, not in On Close of the report.

Bruno

[Phil Stanton]

Thanks Bruno but I cant see how that will work,
I have a number of reports which theoretically I can output as word
documents. I have a form with a list box that shows the reports. On pressing
the print button on the form, it adds code to the OnPrint sections of the
selectede report to initiate the output to Word routines. In order to output
the whole report to Word, the user has to go to the next page until they
reach the end. At that point I want to close the report. All the running
code is initiated by the printing process of the report. How can I detect
the end of the report and pass back control to the form that initiated the
proccess to do the The "DoCmd.Clos e acReport, me.Name, acSaveNo" on the
close event bit

Thanks

Phil

"Bruno Campanini" <br************ ****@tin.it> wrote in message
news:G6******** **************@ news4.tin.it...

"Phil Stanton" <di********@sta ntonfamily.co.u k> wrote in message
news:41******** *************@m ercury.nildram. net...

In code I am opening a report in deign view, adding code to the report to
output it to Word in an editable form. I then want t close the report but
not save the changes.
Is there any way or preventing the option to save changes from being
displayed (the answer is always no)

The "DoCmd.Clos e acReport, me.Name, acSaveNo" on the close event does
not work

TIA

Phil

Put
DoCmd.Close acReport, ReportName, acSaveNo
in your code, not in On Close of the report.

Bruno

[Bruno Campanini]

"Phil Stanton" <di********@sta ntonfamily.co.u k> wrote in message
news:41******** *************@m ercury.nildram. net...

Thanks Bruno but I cant see how that will work,
I have a number of reports which theoretically I can output as word
documents. I have a form with a list box that shows the reports. On
pressing the print button on the form, it adds code to the OnPrint
sections of the selectede report to initiate the output to Word routines.
In order to output the whole report to Word, the user has to go to the
next page until they reach the end.
I.e. in preview mode the user presses PagDown?
At that point I want to close the report. All the running code is
initiated by the printing process of the report. How can I detect the end
of the report and pass back control to the form that initiated the
proccess to do the The "DoCmd.Clos e acReport, me.Name, acSaveNo" on the
close event bit

I'm not sure to understand ok.
In any case if you are in the Form, you can't send
"DoCmd.Clos e acReport, me.Name, acSaveNo"
because Me.Name means, in the circumnstance,
the Form's Name.
Replace Me.Name with "ReportXXX" or a variable
containing the Report's Name.

In order to allow the Report's operations to
complete try adding DoEvents in your Form's
print button:

..............
..............
DoEvents
DoCmd.Close acReport, "ReportXXX" , acSaveNo

Ciao
Bruno