Ms Access Error 30014
help? Post your question and get tips & solutions from a community of 418,595 IT Pros & Developers. It's quick & easy. Trapping/disabling runtime error 30014 P: n/a Jim Armstrong Hello all - This is driving me crazy. I have a table called tblClients - very simple, has the following fields: taxID (PK) ClientName SalesName The main form of my application allows a user to select a client and shows sales transactions on a subform. I wanted to include a button the user could click which would allow them to edit the client information. So, I created a form called frmEditClient which is loaded when the button is clicked. Code on the OnClick event for the code button: Private Sub cmdEditClient_Click() Dim LinkCriteria As String LinkCriteria = "[ClientName]= '" & Me.txtSelectedCLient & "'" DoCmd.OpenForm "frmEditClient", , , LinkCriteria End Sub Pretty simple, just opens the EditClient form using the current client in the recordsource - this opens the form and the user can edit details and save the form. The recordsource of frmEditClient is a query called vwEditClient that selects all from tblClients (tried using tblClients as record source - same problem) Only problem is if the user wants to edit the ClientName field - since frmEditClient is using the ClientName field as a filter, I get a runtime error 30014 - the data has been added but cannot be displayed because it no longer meets the criteria of the underlying recordsource. I know *why* I'm getting the error, I just want to stop it. I've tried to trap the damn thing, but can't seem to get it to trap - the error is generated on the "me.dirty=false" line, and this stops any code after from running. I have tried to put On Error Goto 0 at the beginning of the sub, etc..., but nothing seems to trigger. Here is the code for the Save button, without any error handling: Private Sub cmdSave_Click() If Me.Dirty Then Me.Dirty = False Else MsgBox ("No changes were detected - please make your changes, or hit Cancel to return to the previous screen") Exit Sub End If DoCmd.Close acForm, "frmEditClient" End Sub All I want is: 1) A way to load the frmEditClient so the form displays the client that was selected on the main form 2) A way to suppress or hide the runtime error that occurs when the user edits the clientname. Can someone assist with a way to trap this error or prevent it from happening? Thanks Jun 27 '08 #1 Post Reply Share this Question 3 Rep
this error, but have found more confusing pieces to this error message. I have a continous form, in which I want to get the ID for that record as soon as a message box is choosen from. I posted the same question on Friday and Vadim Rapp did a wonderful job answering the question for me. But strangely no matter what I try, when I choose a certain combinaton from the drop down boxes I get this error: Runtime error '30014': The data was added to the database but the data won't be displayed in the form because it doesn't satisfy the criteria in the underlying record source. It is very odd, the subform record remains blank, but once I scroll one record https://bytes.com/topic/access/answers/810435-trapping-disabling-runtime-error-30014-a forward or backwards the data displays. I look in the tables and the data is saved correctly and relates to the other tables correctly. The subform itself has only one table as a record source. I am not sure what can be causing this error, but it actually saves the data correctly. More of a nuesance for the users. The error also only occurs when certain combinatoins of the drop down boxes are choosen from, most choices in the drop down boxes http://www.pcreview.co.uk/threads/run-time-error-30014.1625692/ do not give this error. If anyone has run into this error before let me know. Any help would be greatly appreciated. TBernard TBernard, Dec 8, 2003 #1 Advertisements Karen Vaudreuil Guest Hi, I had this problem a couple of times and if I remember well, creating a view, instead of putting the table or an adhoc query as the recordsource solved the problem. Try this and you'll see. Karen "TBernard" <> wrote in message news:07ef01c3bdc1$72e05c70$... > I posted earlier about this error, but have found more > confusing pieces to this error message. > > I have a continous form, in which I want to get the ID for > that record as soon as a message box is choosen from. I > posted the same question on Friday and Vadim Rapp did a > wonderful job answering the question for me. > > But strangely no matter what I try, when I choose a > certain combinaton from the drop down boxes I get this > error: > > Runtime error '30014': > > The data was added to the database but the data won't be > displayed in the form because it doesn't satisfy the > criteria in the underlying record source. > > It is very odd, the subform record remains blank, but once > I scroll one record forward or backwards the data > displays. I look in the tables and the data is saved > correctly and relat
Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rate Thread Display Modes 02-27-2007, 12:51 AM #1 Pablo Registered User Join Date: Feb 2007 Posts: 3 Thanks: 0 http://www.access-programmers.co.uk/forums/showthread.php?t=123827 Thanked 0 Times in 0 Posts Error 30014 I am working in a ADP / SQL2000 Enviroment. In a subform i get the data from SQL server with a stored procedure. When i change a value of a record in the subform http://www.tek-tips.com/viewthread.cfm?qid=1620938 i get always the error 30014 and the changed record is no longer visible. After a refresh (Menu: Tools\refresh) also the changed record is visible. Any ideas whats the reason for this? and how can i solve this? Thanks Pablo Pablo ms access View Public Profile Find More Posts by Pablo 02-27-2007, 01:47 AM #2 Dennisk AWF VIP Join Date: Jul 2004 Posts: 1,649 Thanks: 0 Thanked 9 Times in 5 Posts are you sure the error is 30014 and not 3014 as there is no errors > 15999 in BOL? Dennisk View Public Profile Find More Posts by Dennisk 02-27-2007, 03:38 AM #3 Pablo Registered User Join Date: Feb 2007 Posts: 3 Thanks: ms access error 0 Thanked 0 Times in 0 Posts Error 30014 Hallo Yes its realy this number. Err.Number 30014 Err.Description 'The data was added to the database but the data won't be displayed in the form because it doesn't satisfy the criteria in the underlying record source.' It's crazy, that after a refresh this Record will be shown, that means in my opinion that a wrong error is displayed. But how solve this? Thanks Pablo Pablo View Public Profile Find More Posts by Pablo « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Rate This Thread Excellent Good Average Bad Terrible Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Access World Access World News Site Suggestions Introduce Yourself The Watercooler Microsoft Access Discussion General Tables Queries Forms Reports Macros Modules & VBA Theory and practice of database design Access Web Microsoft Access Reference Access FAQs Code Repository Sample Databases Microsoft Access Tutorials Microsoft Access User Groups Apps and Windows SQL Server Crystal Reports Visual Basic VB.NET Word Excel Web Design and Developmen
FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft: Access Project (ADP) Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft: Access Project (ADP) Forum Runtime Error 30014 thread958-1620938 Forum Search FAQs Links MVPs Runtime Error 30014 Runtime Error 30014 primagic (IS/IT--Management) (OP) 21 Sep 10 16:24 I get the following error when from a form after I update a record. I know its because the update makes the record not meet the conditions of the recordset of the form. But how do I work around it. The recordsource for the form is below:CODESELECTdbo.Leads.*, LeadID AS EXPR1, Adviser AS EXPR2, OutcomeID AS EXPR3FROMdbo.LeadsWHERE(OutcomeID = 'Pending') AND (Adviser IS NULL) OR(OutcomeID = 'No Answer') AND (Adviser IS NULL) OR(OutcomeID = 'Engaged') AND (Adviser IS NULL) OR(OutcomeID = 'Future Business') AND (Adviser IS NULL) OR(OutcomeID = 'Waiting on Base Rate Moving') AND (Adviser IS NULL) OR(OutcomeID = 'Scheduled Call Unsuccessful') AND (Adviser = NULL) Red Flag This Post Please let us know here why this po