Microsoft Access Error The Openreport Action Was Cancelled
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
The Openreport Action Was Canceled Access 2010
#1 Ice Rhino Registered User Join Date: Jun 2000 Location: London, United Kingdom Posts: the openreport action was canceled access 2003 210 Thanks: 0 Thanked 0 Times in 0 Posts The Openreport action was canceled error I have been using a database that I ms access error 2501 the openform action was cancelled 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 nothing, and now when I click on the Run Report cmd btn,
Run-time Error '2501' The Openreport Action Was Canceled
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 installed and Epson printer since the last time I used it, No Windows updates, Office Updates etc etc
Access 2010 Error 2501
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 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 th
Ask a Question Need help? Post your question and get tips & solutions from a community of 418,589 IT Pros & Developers. It's quick & easy. Error 2501 The OpenReport action was cancelled... HELP! P: n/a fearblanco 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 http://www.access-programmers.co.uk/forums/showthread.php?t=76338 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 Salad fe********@gmail.com wrote: Hello - I am receiving the below error message when attempting to open a report. This database https://bytes.com/topic/access/answers/204846-error-2501-openreport-action-cancelled-help 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 :) 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
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get https://www.experts-exchange.com/questions/21230362/Run-time-error-2501-The-OpenReport-action-was-canceled-Microsoft-Visual-Basic-pop-up-when-click-on-OK-button-in-previous-Microsoft-Office-Access-pop-up-window-The-OpenReport-action-was-canceled.html Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers http://www.techrepublic.com/forums/discussions/the-openreport-action-was-cancelled/ Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Run-time error 2501:The OpenReport action was canceled (Microsoft Visual Basic pop-up ) when click on OK button in previous Microsoft Office Access pop-up window - The OpenReport action was canceled Want to Advertise Here? Solved Run-time error 2501:The OpenReport action was canceled (Microsoft Visual Basic action was pop-up ) when click on OK button in previous Microsoft Office Access pop-up window - The OpenReport action was canceled Posted on 2004-12-04 MS Access 1 Verified Solution 7 Comments 9,991 Views Last Modified: 2011-08-18 I am computer technicain supporting building with over 2000 users.One of them created Office 97mdb file and converted to Microsoft Acceess 2003.After convertion, some of the users having problem running reports.When they open mdb file and the openreport action click on Report button, they are getting Microsoft Office Access pop-up window : The OpenReport action was canceled.When they click OK then Microsoft Visual Basic window pops-up :Run-time error 2501: The OpenReport action was canceled. I asked users to cross test the issue.Users who are fine logged in to computers where users having this problem and visa-versa.Problematic users still having this problem.Users without problem still working fine being logged in to problematic user's computers.Mdb file is located on a shared folder on a network. Thanks Foxtrot1001 0 Question by:Foxtrot1001 Facebook Twitter LinkedIn Google LVL 54 Best Solution bynico5038 Hmm, then I suspect that these users are using different regional setting. Access can give trouble when e.g. the decimal separator is selected for one as comma and the other a dot. Otherwise you would Go to Solution 5 Comments LVL 54 Overall: Level 54 MS Access 53 Message Expert Comment by:nico50382004-12-04 Check the references on the "error machines". Open some VBA code (e.g. by pressing [CTRL+G]) and select Tools/References. Each libraryname starting with "MISSING" must be unchecked and (e.g. microsoft DAO version x.xx) replaced when necessary. As access doesn't cleanup added libraries, often unnecessary refenreces are present. Just delete as many as possible without getting an error executing "Debug/compile
United States Australia United Kingdom Japan Newsletters Forums Resource Library Tech Pro Free Trial Membership Membership My Profile People Subscriptions My stuff Preferences Send a message Log Out TechRepublic Search GO Topics: CXO Cloud Big Data Security Innovation Software Data Centers Networking Startups Tech & Work All Topics Sections: Photos Videos All Writers Newsletters Forums Resource Library Tech Pro Free Trial Editions: US United States Australia United Kingdom Japan Membership Membership My Profile People Subscriptions My stuff Preferences Send a message Log Out TechRepublic | Forums | Software Software Register Now or Log In to post Welcome back, My Profile Log Out Recent Activity FAQs Guidelines Question 0 Votes Locked The OpenReport action was cancelled By richard.m.hyatt · 9 years ago I open an Access database, which opens fine. I try to print out the database and get the message "The OpenReport action was cancelled". I tried it on other machines and had no problem. I am not a programmer and the only solutions I found dealt with VB script. I tried loading the driver and restarting the computer but didn't work. The database was originally created in access 2000 and I am trying to print with 2003. It will print with other machines running access 2003. Share Flag This conversation is currently closed to new comments. 3 total posts (Page 1 of 1) + Follow this Discussion · | Thread display: Collapse - | Expand + All Answers Collapse - Same Problem by austin · 9 years ago In reply to The OpenReport action was ... I am having the same issue. I cannot print a database report that prints fine from other computers. I have printed it many times before from my computer and no upgrades/changes were made that I am aware of that might explain this sudden error. The database was created under Access 2000 and all machines involved are still running 2000. If you have solved this little mystery since your last post please post again and let me k