Openreport Action Was Cancelled 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
The Openreport Action Was Canceled Access 2010
#1 Ice Rhino Registered User Join Date: Jun 2000 Location: London, United Kingdom the openreport action was canceled access 2003 Posts: 210 Thanks: 0 Thanked 0 Times in 0 Posts The Openreport action was canceled error I have been using a database that
Run-time Error '2501' The Openreport Action Was Canceled
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 nothing, and now when I click on the Run Report ms access error 2501 the openform action was cancelled 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 installed and Epson printer since the last time I used it, No Windows updates, access 2010 error 2501 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 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 _______
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 http://www.access-programmers.co.uk/forums/showthread.php?t=76338 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 http://www.techrepublic.com/forums/discussions/the-openreport-action-was-cancelled/ 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 know. 0Votes Share Flag Collapse - My problem solved! by austin · 9 years ago In reply to The OpenReport action was ... Dumb mistake on my part. The only problem was that I had changed my default printer to Adobe PDF last week. When I changed it back to a real printer I no longer get the error message and can print fine. 0Votes Share Flag Back to Software Forum 3 total posts (Page 1 of 1)  W
Ask a Question Need help? Post your question and get tips & solutions from a community of 418,616 IT Pros & Developers. It's quick & easy. Error 2501 The OpenReport action was cancelled... HELP! P: n/a https://bytes.com/topic/access/answers/204846-error-2501-openreport-action-cancelled-help fearblanco Hello - I am receiving the below error message when attempting to open a http://www.utteraccess.com/forum/open-report-action-cance-t717759.html 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 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 is used by approximately 20 users and only one user is having openreport action was 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. 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
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 avail. Any ideas appreciated. jt R. HicksView Member Profile Jun 1 2005, 06:33 PM Post