Microsoft Access Error 2501 Openreport Action Cancelled
Contents |
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 ms access error 2501 the openform action was cancelled Hello - I am receiving the below error message when attempting to open a report.
Access Run Time Error 2501 Outputto Action Was Canceled
This database is used by approximately 20 users and only one user is having this problem (even I can't duplicate this error on
Access 2010 Error 2501
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
Error 2501 Access
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 this problem (even run time error 2501 the runmacro action was canceled 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 bar, click on it so you
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 14:11:48 GMT by s_wx1202 (squid/3.5.20)
be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register http://www.dbforums.com/showthread.php?1215163-Run-time-Error-2501 link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 7 of 7 Thread: Run-time Error '2501' http://www.accessforums.net/reports/run-time-error-2501-openreport-action-canceled-10179.html Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-06-06,18:55 #1 nckdryr View error 2501 Profile View Forum Posts Computer Monkey Join Date May 2005 Posts 1,191 Unanswered: Run-time Error '2501' Hey guys, I've been having troubles with access. The database is stored on the network drive and is accessed by multiple users. One user has been having troubles just recently in using a search form I created on the database (his screenshot with the action was canceled error is attached). Over the last month, when he tries to use the search form, he will occasionly get this error message. When you click the Search button, the form is supposed to pull up a report that is based on a query that has its criteria from the form (hope that makes sense). But he (and as far as I know, only he) has been having this problem. Does anyone know what may be causing this? Has anyone seen this problem before? And, more importantly, does anyone know how to fix it? Thanks in advance to anyone who can help. Attached Thumbnails Me.Geek = True Reply With Quote 04-06-06,21:30 #2 tcace View Profile View Forum Posts Registered User Join Date Apr 2004 Location outside the rim Posts 1,011 As indicated in your screenshot, the OpenReport action was canceled. Run Time error 2501 most often occurs when something is Canceled. For example, if a report is sent to the printer using the OutputReport action and the user hits cancel while it is spooling, it will return error
a forum dedicated to Microsoft Access, if you want to ask any Access related questions or help other members out, please join our community, the registration is free and takes only one minute. Page 1 of 164 123456789101151101 ... Last Jump to page: Threads 1 to 25 of 4091 Forum: Reports Report generation. Forum Tools Mark This Forum Read View Parent Forum Search Forum Show Threads Show Posts Advanced Search Threads in This Forum Title / Thread Starter Replies / Views Last Post By Need help with a complex report BigOnion Replies: 5 Views: 156 Rating0 / 5 Last Post By aytee111 View Profile View Forum Posts 10-17-2016, 07:34 AM Sum function within query Vinagray@gmail.com Replies: 9 Views: 183 Rating0 / 5 Last Post By pbaldy View Profile View Forum Posts 10-14-2016, 03:23 PM Send email with PDF attachment Rzadziu Replies: 8 Views: 210 Rating0 / 5 Last Post By Rzadziu View Profile View Forum Posts 10-14-2016, 06:08 AM Summary Report in Report footer for 12 months of data Treeivery Replies: 1 Views: 114 Rating0 / 5 Last Post By aytee111 View Profile View Forum Posts 10-14-2016, 06:00 AM Using my new 'Relationship" data to display correctly in my report - a beginners question. castingflame Replies: 1 Views: 109 Rating0 / 5 Last Post By Bulzie View Profile View Forum Posts 10-13-2016, 01:28 PM Duplicating a Report Look and feel Bentley Replies: 1 Views: 65 Rating0 / 5 Last Post By pbaldy View Profile View Forum Posts 10-13-2016, 12:13 PM Multiple lines in a text box not appearing in a report Bentley Replies: 1 Views: 86 Rating0 / 5 Last Post By ItsMe View Profile View Forum Posts 10-12-2016, 01:20 PM Dsum Error when printing report David Randle Replies: 1 Views: 132 Rating0 / 5 Last Post By Ajax View Profile View Forum Posts 10-10-2016, 01:03 AM Suppress subreport footer based on field value in main report smith.jr Replies: 2 Views: 205 Rating0 / 5 Last Post By smith.jr View Profile View Forum Posts 10-07-2016, 03:50 PM Report Nightmare for me wrayman Replies: 13 Views: 274 Rating0 / 5 Last Post By wrayman View Profile View Forum Posts 10-07-2016, 02:03 PM HOW TO? Sum multiple specific rows and load into report? necessityofFate Replies: 5 Views: 132 Rating0 / 5 Last Post By orange View Profile View Forum Posts 10-07-2016, 07:34 AM Preparing report/chart intifad Replies: 1 Views: 93 Rating0 / 5 Last Post By ItsMe View Profile View Forum Posts 10-0