 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / November 2004Prevent 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 > 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 [quoted text clipped - 8 lines] > > Phil Put DoCmd.Close acReport, ReportName, acSaveNo in your code, not in On Close of the report. Bruno 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 >> 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 [quoted text clipped - 14 lines] > > Bruno > Thanks Bruno but I cant see how that will work, > [quoted text clipped - 4 lines] > 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.