Ms Access Openreport Error
Contents |
Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search the openreport action was canceled access 2010 Advanced Search Find All Thanked Posts Go to Page...
The Openreport Action Was Canceled Access 2003
Thread Tools Rating: Display Modes 11-10-2004, 06:32 AM #1 Ice Rhino Registered User Join Date: the openreport action was canceled access 2007 Jun 2000 Location: London, United Kingdom Posts: 210 Thanks: 0 Thanked 0 Times in 0 Posts The Openreport action was canceled error I have been using a database run-time error '2501' the openreport action was canceled 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 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
Ms Access Error 2501 The Openform Action Was Cancelled
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 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,
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 19:13:06 GMT by s_wx1085 (squid/3.5.20)
Ask a Question Need help? Post your question and get tips & solutions from a community of 418,595 IT Pros & Developers. It's quick & easy. Error 2501 The OpenReport action https://bytes.com/topic/access/answers/204846-error-2501-openreport-action-cancelled-help 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 http://www.techrepublic.com/forums/discussions/the-openreport-action-was-cancelled/ 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 action was 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 Salad fe********@gmail.com wrote: Hello - I am receiving the below error message when attempting to open a report. the openreport action 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 :) 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
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 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