« Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Calvin Ford replied Aug 3, 2010 I think you are using a key field from a primary table inside a sub form. One thing, however -- I'm using an SQL statement in the ControlSource slot to set the contents of the dropdown.

In the Save In list, select the folder where you want to save the Microsoft Access backup key. Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's Terms of Use. A trappable error occurs if you try to assign a new value to a read-only field. http://www.pcreview.co.uk/threads/error-3164-cant-update-field.2774235/ Try that and see if the problem is gone. -- Ken Snell "Anita" <> wrote in message news:... >I have a table called Events where EventID is an

MS Access Advertise Here 856 members asked questions and received personalized solutions in the past 7 days. They offer a malware removal guarantee that is not offered by other security software. About Us PC Review is a computing review website with helpful tech support forums staffed by PC experts. Type "command" in the search box...

Click Programs and Features. http://www.dslreports.com/forum/r18864347-Access-Encountering-MS-Access-Error-3164-in-updated-combo-box All Rights Reserved. Post your question and get tips & solutions from a community of 418,417 IT Pros & Developers. Incorrectly editing your registry can stop your PC from functioning and create irreversible damage to your operating system.

Your name or email address: Do you already have an account? see here To avoid data loss, you must be sure that you have backed-up all of your important documents, pictures, software installers, and other personal data before beginning the process. The > "recordset" code below adds a new record to this table and captures the > newly > created EventID in the intNewEventID variable. > > However, the underlying table for About The Author: Jay Geater is the President and CEO of Solvusoft Corporation, a global software company focused on providing innovative utility software.

This prevents > > user from _ > > incorrectly overriding Last Updated data for all existing records tied to > > the current _ > > Last Updated Event record. Sign up now! Disk Cleanup will begin calculating how much occupied disk space you can reclaim. http://axisnice.com/access-error/access-error-75.php Follow the on-screen directions to complete the uninstallation of your Error 3164-associated program.

The system couldn't pass it through due to not being in query pass through. Microsoft Access), reinstall the program according to the Microsoft Corporation instructions. The .DataUpdatable property of a field tells whether the field itself is, in principle, editable.

This field, "Event ID," exists in the query my >> > form >> > is based on, but is not a visible control on the form. >> > >> > Private

Start a new thread here 1722185 Related Discussions Updating sql server 2005 database in Access 2003 Subforms and linked tables How to Add/Create Primary Key Programmatically to a Make Table Query If it was beneficial then you can assign/split them as you see fit. (As for how to assign points - I barely knew how to do that in the old site The best part is that repairing registry errors can also dramatically improve system speed and performance. Click the Uninstall button on the top menu ribbon.

Because an updatable object can contain read-only fields, check the DataUpdatable property of each field in the Fields collection of a Recordset object before you edit a record. Have you Suggested Solutions Title # Comments Views Activity ms Access 6 37 25d MS Access get count of incidents each hour of day 6 18 26d query 01/01/1901 in a Sharepoint list Because of the shortcomings of the Windows Disk Cleanup (cleanmgr) tool, we highly recommend using a specialized hard drive cleanup / privacy protection software such as WinSweeper (Developed by Microsoft Gold http://axisnice.com/access-error/access-error.php As soon as I hit ok everything is fine and I can update the record.

Operating System Information 3164 error messages can occur in any of the following Microsoft Windows operating systems: Windows 10 Windows 8 Windows 7 Windows Vista Windows XP Windows ME Windows 2000