Ms Access Runtime Error 3164
error 3164, field can not be updated, when I try to pass a value to a field. This field, "Event ID," exists in the query my form is based on, but is not a visible control on the form. Private Sub EventDate_BeforeUpdate(Cancel As Integer) 'Created November 2006 - currently in testing 'If user attempts to change the date of the Last Updated event, this sub creates a _ new Event record and plugs the just-inputted data into it. This prevents user from _ incorrectly overriding Last Updated data for all existing records tied to the current _ Last Updated Event record. Dim intNewEventDate As Date Dim intNewEventID As Integer Dim conEvent As Connection Dim rstEvent As Recordset intNewEventDate = Me.EventDate Cancel = True Set conEvent = CurrentProject.Connection Set rstEvent = New Recordset With rstEvent .Source = "Select * from Event" .ActiveConnection = conEvent .LockType = adLockOptimistic .Open .AddNew ![Event Type] = "Last Updated" ![EventDate] = intNewEventDate intNewEventID = ![Event ID].Value .MoveFirst End With rstEvent.Close Set rstEvent = Nothing conEvent.Close Set conEvent = Nothing Me.[Event ID].Value = intNewEventID ******Run-time error 3164********** Me.Requery Guest, Nov 5, 2006 #1 Advertisements Ken Snell \(MVP\) Guest Is EventID an autonumber field? If not, post more details about what it is and more details about your form's setup/design/properties. If it is an autonumber field, you cannot update such a field. -- Ken Snell
Custom Search UtterAccess Forums>Microsoft® Access>Access Forms Error 3164 field can not be updated 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|-- http://www.pcreview.co.uk/threads/error-3164-cant-update-field.2774235/ 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|-- http://www.utteraccess.com/forum/Error-3164-field-updat-t673765.html 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 -
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio http://database.ittoolbox.com/groups/technical-functional/access-l/field-cannot-be-updated-error-3164-1722185 Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design https://www.tutcity.com/access/field-cannot-be-updated-error-3164.85827.html MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX VoIP_News Inside-ERP I_am_the_dragon Inside-CRM maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Locutus Craig Borysowich Dennis Stevenson mircea_luca Richard DukeGanote iudithm Clinton Jones bracke Nikki ms access Klein AbhaiTripathi Iqbalyk jakarman Adrian_Grigoriu knowscognosdoi COMPANIES SendGrid ZOHO Corporation Apperian eFax Corporate View All Topics View All Members View All Companies Toolbox for IT Topics Database Groups Ask a New Question Microsoft Access The Microsoft Access group is for the discussion of issues that arise during the implementation, configuration, administration, or daily use of MS Access. Home | ms access runtime Invite Peers | More Database Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Field cannot be updated (Error 3164) carmel farrugia asked Nov 22, 2007 | Replies (3) Dear All, I have an access 2003 database and I have a form that enables the user to enter new rows. Now I am upgrading the database and I have carried numerous developments. However, it started giving me the error of 'Field cannot be updated. (Error 3164).' I looked at previous version and I cannot find what could have happened. Can anyone shed
has worked fine over a long period of time. you used to be able to type in the first number or letter of the part and it would filter down until the correct part was seen. now when you type in the first character I get the 'field cannot be updated' error saying that something is locked and wait for someone to get out.etc. No one else is in this database. The combo box query comes from a linked table. Once you clear the error by clicking ok on the error box everything works fine. Sponsored Links: Read full post... Report an issue Thank you for taking the time to report an issue. What's wrong... Please write below. And write your email address (optional) Similar posts... Cumulative totals: Cannot edit a field in recordset I want to calculate the cumulative totals for each account in my database I created a query qCumTot with four fields Account: text field sort ascending from another table Date: Income: Currency from another table CumTot: Created in this query and set to set = 0 I intended to overwrite CumTot using visual basic so I could see the results in the output of the query Dim db As Database Dim rs As Recordset Set db = CurrentDb() Set rs = db.OpenRecordset("qCumTot") Looping thorough record set I can calculate CumTotal But I cannot overwrite rs![CumTot} rs.Edit rs![CumTot] = CumTotal Gives Error 3164: Field cannot be updated, another process has locked record or table field cannot be updated All of a sudden, I get "the field cannot be updated" error when trying to add a new record in my data entry form. The form worked fine before. I doesn't matter what field I enter data into, I get the error. I click OK and then it lets me continue entering information. Puzzled as to why this is happening. Adding multiple data to one field I would like to be able to have the date written in to a field when another field is updated. Pretty simple, however, there are circumstances that this field could be updated as many as 6 times. I will have to build a query that will search this fie