Access Error The Openreport Action Was Canceled
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Fri, 30 Sep 2016 01:07:38 GMT by s_hv987 (squid/3.5.20)
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: ms access error 2501 the openform action was cancelled Display Modes 11-10-2004, 06:32 AM #1 Ice Rhino Registered User Join Date:
Error 2501 Access
Jun 2000 Location: London, United Kingdom Posts: 210 Thanks: 0 Thanked 0 Times in 0 Posts The Openreport action was canceled
Access 2010 Error 2501
error I have been using a database that I constructed for a while now and all is well with it. Well all was well with it until I went to use it today, having changed http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_other/openreport-action-was-canceled-error-2501/acf5d04e-e6a4-4a29-9a89-a9ff74c4d8c5 nothing, and now when I click on the Run Report cmd btn, I get the The Openreport action 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 http://www.access-programmers.co.uk/forums/showthread.php?t=76338 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 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 decompil
Ask a Question Need help? Post your question and get tips & solutions from a community of 418,417 IT Pros & Developers. It's quick & https://bytes.com/topic/access/answers/204846-error-2501-openreport-action-cancelled-help easy. Error 2501 The OpenReport action was cancelled... HELP! P: n/a fearblanco Hello http://www.utteraccess.com/forum/open-report-action-cance-t717759.html - 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 this error on my own PC). The command being used is DoCmd.OpenReport "rptSYS_ChangeInARDaily", acViewPreview OR DoCmd.OpenReport "rptSYS_ChangeInARDaily", acViewPreview, action was , "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 Nov 13 '05 #1 Post Reply Share this Question 5 Replies P: n/a the openreport action 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 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
Custom Search UtterAccess Forums>Microsoft® Access>Access Reports Open Report Action Was Cancelled Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code Archive|-- Access Knowledgebase / FAQ|-- Access TutorialsMicrosoft® Access|-- Local Access User Groups (AUGs)|-- Interface Design|-- Access Q and A|-- Access Tables + Relationships|-- Access Queries|-- Access Forms|-- Access Reports|-- Access Macros|-- Access Modules|-- Access Date + Time|-- Access Errors + Error Handling|-- Access Built-in Functions|-- Access Searching + Data Mining|-- Access Records|-- Access Security|-- Access Automation|-- Access Database Container|-- Tool bars, Menu bars + Ribbon|-- Access Services (Web Databases)|-- Access Data Access Pages (Deprecated)|-- Access Data Projects - ADP|-- Access Runtime, Packaging & DeploymentAnd More...|-- Microsoft SQL Server|-- SQL Server Reporting Services|-- Microsoft SharePoint|-- Microsoft Internet Explorer|-- Visual Basic 6 and Earlier|-- Visual Basic 2003 and Later|-- ASP and VBScript|-- Web Development|-- PHP, Perl, MySQL and Postgres|-- Other Database Engines|-- BI Tools and Applications|-- JAVA and C#|-- GraphicsMicrosoft® Office|-- Microsoft Excel|-- Microsoft Excel FAQs|-- Microsoft Word|-- Microsoft Outlook|-- Microsoft PowerPoint|-- Microsoft FrontPage/Exp. Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- Q & A - UtterAccess.com Forums|-- Q & A - Access Wiki Options jtvcsView Member Profile Jun 1 2005, 06:27 PM Post#1Posts: 147Joined: 3-March 03From: New Jersey, USAAnyone ever experience this error when a user clicks a VB coded button using Open Report. The odd thing is only one person using the database gets this error. We remove, then reloaded Office 2003 to no avai