Microsoft Access Runtime Error 2501
Contents |
Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go ms access error 2501 the openform action was cancelled to Page... Page 1 of 2 1 2 > Thread
Runtime Error 2501 The Outputto Action Was Cancelled
Tools Rating: Display Modes 02-05-2007, 02:33 PM #1 ShanVel ShanMug Join Date: Oct 2005 Location: Akron, access 2010 error 2501 OH, USA Posts: 51 Thanks: 0 Thanked 0 Times in 0 Posts Run-time error 2501; OpenReport action was cancelled Folks, Need your help. I searched the entire forum and found couple run time error 2501 the save action was canceled of postings on this, but none of them indicates if there is any fix for this problem. If there is no data, basically I want to show a message and close the report. I have some code to handle this under no data event like below: Private Sub Report_NoData(Cancel As Integer) MsgBox "There is no data for this report. Canceling report..." Cancel
Run Time Error 2501 The Runmacro Action Was Canceled
= True End Sub But this 2501 always pops up and I couldn't find a way to stop this. I also searched Microsoft knowledgebase, no help. Here's how my clik event procedure looks like: Private Sub cmdSearch_Click() On Error GoTo Err_PreviewRprt Dim strTbl As String Dim strSQL As String Dim strOptItem As String Dim strOptBlrType As String Dim strMsg As String, strTitle As String Dim intStyle As Integer 'Set up SQL statement for report record source If IsNull(optCriteria) Then optCriteria = 1 strTbl = Me.cboTypeOfGuar.Column(0) strOptItem = Choose(optCriteria, "memPred", "memGuar", "memRiskLevel", "memLDs") strOptBlrType = Choose(optBoilerType, "SWUP", "RB", "CFB", "All") strSQL = "SELECT tblProjts1.chrProjectName, tblProjts1.chrBlrPropNum, tblProjts1.chrBoilerType, " & _ strTbl & ".memGuranItem, " & strTbl & "." & strOptItem & _ " FROM tblProjts1 INNER JOIN " & strTbl & " ON " & _ "tblProjts1.intProjectId = " & strTbl & ".intProjectId" & _ " WHERE (((" & strTbl & ".memGuranItem)" & " IS NOT NULL)" & " AND " & "((tblProjts1.chrBoilerType) = '" & strOptBlrType & "'))" 'Open report in Design view to set the report's record source 'and search item label's capt
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 13:40:21 GMT by s_wx1062 (squid/3.5.20)
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more http://stackoverflow.com/questions/4683163/run-time-error-2501 about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack https://www.experts-exchange.com/questions/27908573/Run-time-error-2501-in-Access.html Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Run Time Error '2501' up vote 1 down vote favorite I'm error 2501 having the Run Time Error '2501' on a Form. Does anyone have ideas of why this happens and how to fix it? The Report is called through this code: Private Sub Command92_Click() DoCmd.SetWarnings Off ''# get current reqid and version number DoCmd.OpenQuery "NewReqVersion", acViewNormal Dim NewReqID As Integer Dim NewVerID As Integer NewReqID = Me.Text58 NewVerID = Me.Version + 1 [Forms]![UWReviewForm].[StatusID] = 99 On Error Resume Next **DoCmd.Save acForm, time error 2501 "UWReviewForm"** DoCmd.OpenForm "NewReqVersionForm", acNormal DoCmd.GoToRecord acDataForm, "NewReqVersionForm", acLast End Sub Private Sub StatusID_Change() Me.LastModifiedTimeStamp = Now() End Sub vba ms-access runtime-error share|improve this question edited Nov 12 '12 at 6:15 Cheran Shunmugavel 6,12211732 asked Jan 13 '11 at 17:32 user574629 6112 1 Get rid of "On Error Resume Next" - it should only rarely be used. What code runs on load or on open for NewReqVersionForm? –Fionnuala Jan 13 '11 at 19:45 In never use it outside and error handler. –David-W-Fenton Jan 15 '11 at 3:05 DoCmd.Save acForm saves the design of the form, not the data displayed in it, so it looks to me like that line is not doing anything useful at all. If you want to save the change to the data in that form, use Forms!UWReviewForm.Dirty = False. –David-W-Fenton Jan 15 '11 at 3:06 add a comment| 2 Answers 2 active oldest votes up vote 2 down vote The error 2501 can occur on calling OpenForm if there is a problem with the database. Can you please try following the steps in the link below under the headings "Recovering from corruption" and "Symptom: Cannot open a form or report"? MS Access - Recovering from corruption share|i
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 Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Run-time error 2501 in Access Want to Advertise Here? Solved Run-time error 2501 in Access Posted on 2012-10-21 MS Access Programming MS Applications 1 Verified Solution 9 Comments 3,425 Views Last Modified: 2012-10-21 All of a sudden our Access 2003 "application" isn't working. We have this database complete with forms, multiple tables, queries, etc. When I attempt to open a form, via a button, I get: Microsoft Visual Basic Run-time error 2501 The OpenForm action was canceled. Clicking the debug button brings me to it's click event... highlighting the following line: DoCmd.OpenForm "frmInputNew" So... I go to the frmInputNew form and look in the Open event to see: Dim test As Variant 'set focus on Lot Inventory Me.OrderBy = "" Me.tabAfterPurchase.SetFocus Not a lot to see... if I comment out these three lines I still get the same error. Any thoughts? 0 Question by:classnet Facebook Twitter LinkedIn Google LVL 61 Active today Best Solution bymbizup If this "just started happening" - ie: with no recent design or code changes - then it is possible that your form is corrupt. First - make a backup Then compact/repair the database. If that Go to Solution 9 Comments LVL 61 Overall: Level 61 MS Access 60 MS Applications 14 Programming 4 Message Active today Expert Comment by:mbizup2012-10-21 Does the form open normally if you double-click it's name in the database window? Also, do you have any code in the Load, Activate or Current events? And what is in the form's Recordsource property? 0 Message Active 1 day ago Author Comment by:classnet2012-10-21 The form does not open normally... I get a "The expression On Open you entered as the event property setting produced the following error: Syntax error". The RecordSource property references the query qryInputWShow. I can run qryInputWShow fine by itself. There is no code in the Load ev