Ms Access The Openreport Action Was Canceled Error
Contents |
Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rating: Display Modes 11-10-2004, 06:32 AM #1 Ice Rhino
The Openreport Action Was Canceled Access 2010
Registered User Join Date: Jun 2000 Location: London, United Kingdom Posts: 210 Thanks: 0 Thanked the openreport action was canceled access 2003 0 Times in 0 Posts The Openreport action was canceled error I have been using a database that I constructed for a while now run-time error '2501' the openreport action was canceled and all is well with it. Well all was well with it until I went to use it today, having changed nothing, and now when I click on the Run Report cmd btn, I get the The Openreport action
Ms Access Error 2501 The Openform Action Was Cancelled
was canceled everytime. Other people use this report/database and it works erfectly for them, it is only me it does not work for. The database was designed in 2003 although all other users only use Access 2000. File Format is in 2000 too. Literally nothing has changed apart from the fact I have installed and Epson printer since the last time I used it, No Windows updates, Office Updates etc etc have been applied. The basic code behind the button
Access 2010 Error 2501
is Private Sub cmd_btn_rep_1_Click() On Error GoTo Err_cmd_btn_rep_1_Click Dim stDocName As String stDocName = "rpt_centre_dashboard" DoCmd.OpenReport stDocName, acPreview DoCmd.RunCommand acCmdFitToWindow Exit_cmd_btn_rep_1_Click: Exit Sub Err_cmd_btn_rep_1_Click: MsgBox Err.Description Resume Exit_cmd_btn_rep_1_Click End Sub Anybody able to shed any light on this problem? One thing I have just noticed is that I am not even able to open the report in Design View. Nothing happens, machine just sits there doing nuffing Regards Toni __________________ Toni Chaffin Last edited by Ice Rhino; 11-10-2004 at 06:36 AM. Ice Rhino View Public Profile Find More Posts by Ice Rhino 11-10-2004, 07:53 AM #2 sfreeman@co.mer Sam_F Join Date: Aug 2004 Posts: 272 Thanks: 0 Thanked 0 Times in 0 Posts Assuming that you have stepped thru this code and any related code and still cannot find the problem.... Report or query or table upon which the report is based may be corrupt. Try a compact and repair. If still no go, create a new db, and import all objects from original db into the new db. If still no go, try a decompile. BE CAREFUL. See links below for more info. http://www.mvps.org/access/bugs/bugs0008.htm http://www.granite.ab.ca/access/decompile.htm If that fails, recreate the report (or try this first if the report is not too complex). HTH __________________ 90% of the problem is asking the right question. sfreeman@co.mer View Public Profile Find More Posts by sfreeman@co.mer 11-10-2004, 0
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 21:40:41 GMT by s_wx1157 (squid/3.5.20)
help? Post your question and get tips & solutions from a community of 418,595 IT Pros https://bytes.com/topic/access/answers/849373-stop-open-report-cancelled & Developers. It's quick & easy. Stop "The open report was cancelled" P: n/a Phil Stanton I am opening a report (in Preview) from a menu system I use the following code if there is no data in a report Private Sub Report_NoData(Cancel As Integer) MsgBox "There are no errors in Membership Head of Families", vbInformation action was Cancel = True End Sub After this message comes up and is cleared with the OK Button. Access generates a second annoying message that "The OpenReport Action was canceled" ( Note Microsoft can't spell 'cancelled' certainly in A2K, but perhaps that is American) Anyway how do I stop this second message appearing. Thanks Phil Oct 28 '08 the openreport action #1 Post Reply Share this Question 4 Replies P: n/a ARC Well, in code you would check for the err=2501 in your error routine and simply exit: Private Sub Report_NoData(Cancel As Integer) on error goto ErrRtn MsgBox "There are no errors in Membership Head of Families", vbInformation Cancel = True Exit Sub ' ErrRtn: If Err = 2501 Then 'Open report was cancelled Exit Function else msgbox err.number & " - " & err.description end if end sub "Phil Stanton"