469,644 Members | 1,781 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,644 developers. It's quick & easy.

Prevent saving a report

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.Close acReport, me.Name, acSaveNo" on the close event does not
work

TIA

Phil
Nov 13 '05 #1
3 3576
"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:41*********************@mercury.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.Close 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
Nov 13 '05 #2
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.Close 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********@stantonfamily.co.uk> wrote in message
news:41*********************@mercury.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.Close 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

Nov 13 '05 #3
"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:41*********************@mercury.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.Close 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.Close 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
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Bob Murdoch | last post: by
5 posts views Thread by Vincent | last post: by
6 posts views Thread by Eddie | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.