Access Run-time Error 2501 Openreport Action Was Cancelled
Contents |
One games Xbox 360 games PC ms access error 2501 the openform action was cancelled games Windows games Windows phone games Entertainment All access 2010 error 2501 Entertainment Movies & TV Music Business & Education Business Students & access run time error 2501 outputto action was canceled educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security
The Openreport Action Was Canceled Access 2010
Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Band Microsoft the openreport action was canceled access 2003 Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
Ask a Question Need help? Post your question and get tips & solutions from a community of 418,417 IT Pros & Developers. It's quick & easy. Error 2501 The OpenReport action was cancelled... HELP! P: n/a fearblanco Hello run-time error 2501 the close action was cancelled - I am receiving the below error message when attempting to open a report. This
Run Time Error 2501 The Runmacro Action Was Canceled
database is used by approximately 20 users and only one user is having this problem (even I can't duplicate this error on my own
The Openform Action Was Canceled Access 2013
PC). The command being used is DoCmd.OpenReport "rptSYS_ChangeInARDaily", acViewPreview OR DoCmd.OpenReport "rptSYS_ChangeInARDaily", acViewPreview, , "Collector= '" & cmbAnalyst.Value & "'" This one particular user gets the following message: Error: 2501 - ErrorDesc: The OpenReport action was canceled Can https://support.microsoft.com/en-us/kb/913031 anybody explain why this would happen to only one person? The data is there, so I can't see why the report would cancel. Please help, fe********@gmail.com Nov 13 '05 #1 Post Reply Share this Question 5 Replies P: n/a Salad fe********@gmail.com wrote: Hello - I am receiving the below error message when attempting to open a report. This database is used by approximately 20 users and only one user is having this problem (even I can't duplicate https://bytes.com/topic/access/answers/204846-error-2501-openreport-action-cancelled-help this error on my own PC). The command being used is DoCmd.OpenReport "rptSYS_ChangeInARDaily", acViewPreview OR DoCmd.OpenReport "rptSYS_ChangeInARDaily", acViewPreview, , "Collector= '" & cmbAnalyst.Value & "'" This one particular user gets the following message: Error: 2501 - ErrorDesc: The OpenReport action was canceled Can anybody explain why this would happen to only one person? The data is there, so I can't see why the report would cancel. Please help, fe********@gmail.com It's possible you have the OnNoData to cancel the report or you have a Cancel in the OnOpen event. If so, in the calling form, add to your error routine If Err.Number <> 2501 then msgbox Err.Description Resume YourExitStatementLine Nov 13 '05 #2 P: n/a fearblanco This would make sense but the other 19 people using the same exact report dont have this problem. and there is no OnNoData event or OnOpen event for this report. I'll try what suggested and hope it works :) Nov 13 '05 #3 P: n/a Salad fe********@gmail.com wrote: This would make sense but the other 19 people using the same exact report dont have this problem. and there is no OnNoData event or OnOpen event for this report. I'll try what suggested and hope it works :) Open your code window and to to the DoCmd.OpenReport "rptSYS_ChangeInARDaily", acViewPreview line. On the vertical bar, click on it so you can step through the process. Then exect
question and get tips & solutions from a community of 418,417 IT Pros & Developers. It's quick https://bytes.com/topic/access/answers/889472-run-time-error-2501-a & easy. Run time error 2501 P: 31 tomric Hi, I have an option group to select different reports, each report is based off a query that asks for criteria for that report. I have no problem opening any the querys through the group regardless of the data involved. The problem arises when you go to open a action was report and click the cancel button on the criteria question. I get a "Run Time Error 2501", "The Open Report Action was canceled". The error occurs only on the reoprt in the elseif statement. The grpreport = 6 opens other forms that have the criteria on the form, because there are 14 different criterias the query looks at. The action was canceled grprrport = 6 also uses a macro for that specific report. The code I used is as to open the reports is as follows: Expand|Select|Wrap|Line Numbers PrivateSubcmdreport_Click() OnErrorGoToErr_cmbreport_Click DimstDocNameAsString DimstLinkCriteriaAsString IfMe.grpreports=6Then DoCmd.Close stDocName="designtype" DoCmd.OpenFormstDocName,,,stLinkCriteria ElseIfMe.grpreports=1Then DoCmd.Close DoCmd.OpenReport"rawdataforabar",acViewReport Exit_cmbreport_Click: ExitSub IfErr.Number=2501Then ResumeNext Else Err_cmbreport_Click: MsgBoxErr.Description ResumeExit_cmbreport_Click EndIf EndIf EndSub The program stops at the DoCmd.openreport line. I won't added the rest of the option buttons for reports untill I get past this problem. Can anyone help me capture the error? Jun 3 '10 #1 Post Reply ✓ answered by patjones I think the way for you to solve this is to determine which set of criteria you need some other way - say by entering it on the form, then passing that criteria to the report using the filter argument of OpenReport. This is generally how a report is filtered. As a simple example of how this works, suppose I have a table called tblEmployees, with fields fldEmplID, fldLastName, fldFirstName, fldDateOfB