Docmd.openreport Runtime Error 2501
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more
Runtime Error 2501 Openform Action Was Canceled
about Stack Overflow the company Business Learn more about hiring developers or posting ads runtime error 2501 the outputto action was cancelled with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow runtime error 2501 access is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Access: Canceling Report generation causes error 2501 up vote 0 down vote
Ms Access Error 2501 The Openform Action Was Cancelled
favorite can't believe I am losing so much time on this one. I have an order form, and when I click on a button "reports", a dialog pop ups with a list of different reports to chose from. Double-clicking selects and starts the correspondent report. On one of these reports, there is an unbound text box I need the user to enter data with. The ControlSource of this field is
Access Run Time Error 2501 Outputto Action Was Canceled
set to its Name property. When the report is started, an input box appears with an OK and a Cancel button. Whenever I enter some data, all is fine. But when I click on Cancel, the app crashes and I get an errormessage: "Runtime Error 2501: The Action OpenReport has been canceled" (translated from German). The Report is called through this code: DoCmd.OpenReport vBerichtName, nAnsicht End If On Error Resume Next DoCmd.Close acForm, "F_BerichtDrucken" On Error GoTo 0 1) Why does the error handling not kick in? 2) I googled and found lots of weird solutions for this, like the official Microsoft one saying you need to install/update a printer driver (come on...). None helped. I am doing this for a friend and I normally work on linux/php,java, etc. I apologize if the solution is somewhat obvious or something like that. ms-access report share|improve this question asked Sep 29 '09 at 12:26 faboolous 1,46922553 add a comment| 4 Answers 4 active oldest votes up vote 2 down vote accepted Ditto to Phillipe's answer. you didn't give us the whole procedures but you need to do something like this... Sub MyButton_Click On Error Goto myError DoCmd.OpenReport vBerichtName, nAnsicht MyExit: Exit Sub MyError: If Err.number = 2501 then
be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To access 2010 error 2501 start viewing messages, select the forum that you want to visit from the
Run-time Error 2501 The Close Action Was Cancelled
selection below. Results 1 to 7 of 7 Thread: Run-time Error '2501' Tweet Thread Tools Show Printable Version Subscribe to run time error 2501 the runmacro action was canceled this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-06-06,18:55 #1 nckdryr View Profile View Forum Posts Computer Monkey Join Date May 2005 http://stackoverflow.com/questions/1492231/access-canceling-report-generation-causes-error-2501 Posts 1,191 Unanswered: Run-time Error '2501' Hey guys, I've been having troubles with access. The database is stored on the network drive and is accessed by multiple users. One user has been having troubles just recently in using a search form I created on the database (his screenshot with the error is attached). Over the last month, when he tries to use the search form, he http://www.dbforums.com/showthread.php?1215163-Run-time-Error-2501 will occasionly get this error message. When you click the Search button, the form is supposed to pull up a report that is based on a query that has its criteria from the form (hope that makes sense). But he (and as far as I know, only he) has been having this problem. Does anyone know what may be causing this? Has anyone seen this problem before? And, more importantly, does anyone know how to fix it? Thanks in advance to anyone who can help. Attached Thumbnails Me.Geek = True Reply With Quote 04-06-06,21:30 #2 tcace View Profile View Forum Posts Registered User Join Date Apr 2004 Location outside the rim Posts 1,011 As indicated in your screenshot, the OpenReport action was canceled. Run Time error 2501 most often occurs when something is Canceled. For example, if a report is sent to the printer using the OutputReport action and the user hits cancel while it is spooling, it will return error 2501, which you can trap. Also, if the OpenForm method is called and something causes the form to cancel opening (either Cancel was set to True during open, or an unhandled error
this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register http://www.dbforums.com/showthread.php?1669251-quot-Runtime-error-2501-The-open-report-was-cancelled-quot before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 7 of 7 Thread: "Runtime error 2501-The open report was cancelled" Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display error 2501 Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-17-11,06:17 #1 GinTop View Profile View Forum Posts Registered User Join Date Aug 2011 Posts 19 Unanswered: "Runtime error 2501-The open report was cancelled" I have a query that when run uses the date field criteria to search between two sepcified dates: Between [Enter begining date (eg time error 2501 01/06/11):] And [Enter Finish Date (eg 01/07/11):] When the report is run, the dialogue box first asks for the beginning date then end date, if the user enters a date then clicks ok it works fine. The problem is if the user selects cancel, it breaks and the above Runtime error is displayed. If the query is based on the following code: Code: Private Sub Command57_Click() If IsNull(Me.Combo51) Or Me.Combo51 = "" Then MsgBox "You must enter a directorate.", vbOKOnly, "Required Data" Me.Combo51.SetFocus Exit Sub End If DoCmd.Minimize DoCmd.OpenReport "rptDirectorate", acViewPreview DoCmd.Close acForm, "RunReports", acSaveNo End Sub is there a way of avoiding the error if cancel is clicked in the dialogue box? Reply With Quote 08-17-11,07:58 #2 Sinndho View Profile View Forum Posts Moderator Join Date Mar 2009 Posts 5,440 Provided Answers: 14 Try: Code: Private Sub Command57_Click() On Error Goto Err_Command57_Click If IsNull(Me.Combo51) Or Me.Combo51 = "" Then MsgBox "You must enter a directorate.", vbOKOnly, "Required Data" Me.Combo51.SetFocus Exit Sub End If DoCmd.Minimize DoCmd.OpenReport "rptDirectorate", acViewPreview DoCmd.Clo