field cannot be updated. error 3164 Lithia Springs Georgia

Address 2660 Godby Rd, Atlanta, GA 30349
Phone (404) 855-5855
Website Link

field cannot be updated. error 3164 Lithia Springs, Georgia

If it is an autonumber field, you cannot update such a field. -- Ken Snell "Anita" <> wrote in message news:... > I'm running into run-time error 3164, A form does not expose it's calculation dependenc… MS Access Using Automation to Control Outlook from Access Video by: TechMommy Get people started with the process of using Access VBA to If you're having a computer problem, ask on our forum for advice. Nov 24 '14 #2 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account.

PCMag Digital Group AdChoices unused Home Products Services Learning Forum Contact Access World Forums > Microsoft Access Discussion > Forms Field Cannot Be Updated Error User Name Remember Me? The answer is yes. We appreciate your feedback. Join the community of 500,000 technology professionals and ask your questions.

ShannonStauntonView Member Profile Apr 4 2005, 10:04 AM Post#2Posts: 2Joined: 4-April 05From: Queensland AustraliaIs there any code running on that field.Can you do a screen dump so we can have a Already a member? There are no other users as I am on a single PC and it is the only thing running. Microsoft Access is a very powerful client/server development tool.

All property control settings are set to no locks. The subform is part of data entry screen where the detail items are entered. I compared properties with a similar subform but could not see any obvious differences. About Us PC Review is a computing review website with helpful tech support forums staffed by PC experts.

The problem was rather wh… MS Access Creating the Form event “On Recalculate” Article by: harfang This isn't a frequent question on EE. However, the underlying table for the LastUpdated form where this event is triggered is not the Events table; it's a join table called Entity-Event-Join. Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- floppybootstomp posted Oct 14, 2016 at 3:53 PM Toe-tale Taffycat posted Oct 14, 2016 at 11:04 AM WCG Stats Friday 14 October 2016 WCG Stats posted Oct 14, 2016 at 8:00

Top This thread has been closed due to inactivity. Is the form a standard form bound to a table? Database or object is read-only. ' "Cannot update, databse or object may be read only" Using the MonthView Control But Cannot Update the Text Field on Another Form Cannot update. Post your question and get tips & solutions from a community of 418,550 IT Pros & Developers.

I'd imagine one of the issues touched on above was at play in the query (perhaps the binding to PK rather than FK). 0 Message Author Comment by:dcruz19772007-02-15 Your suggestions When I open the form and start to enter new data in the first field I get an error message saying "Field Cannot Be Updated." When I hit help to see Dinh, Nov 5, 2006 #3 Guest Guest I have a table called Events where EventID is an autonumber field. The time now is 08:44 AM. Microsoft Access Help General Tables Queries Forms Reports Macros Modules & VBA Theory & Practice Access FAQs Code Repository Sample Databases Video Tutorials Sponsored

In Microsoft Access, you tried to change the value of a control whose Locked property is set to Yes. programboyView Member Profile Apr 4 2005, 10:26 PM Post#4Posts: 9Joined: 24-March 05stop,,,,, I was looking things over very close and found problem. Your help is so appreciated please continue with me. The Event ID (from the join table) is part of the form's underlying query.

I know it does not give a reason for the problem but it worked for me Hugheswt View Public Profile Find More Posts by Hugheswt

Many Thanks, Larry Nov 19 '14 #1 Post Reply Share this Question 1 Reply Expert 100+ P: 1,913 twinnyfo Larry, Are the fields being added to a subform? essence View Public Profile Find More Posts by essence
05-21-2007, 04:13 AM #2 essence Registered User Join Date: Nov 2006 Posts: 21 Thanks: 0 Thanked 0 Also, all of the values of the controls are set to NO LOCKS.

Register Privacy Policy Terms and Rules Help Popular Sections Tech Support Forums Articles Archives Connect With Us Twitter Log-in Register Contact Us Forum software by XenForo™ ©2010-2016 XenForo Ltd. Seems to blow up on the Me!Refresh line on other field After Update. The declaration: Dim intNewEventDate As Date is a bit different from the usual naming conventions ... -- HTH Van T. Password Register FAQ Community Top Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find

Yes, I can update other controls on the form and subform. Help, this is driving me crazy! -Jason mccallradar View Public Profile Find More Posts by mccallradar

09-02-2007, 10:30 PM #2 MStef Newly Registered User Join The system couldn't pass it through due to not being in query pass through. One problem may be that you're running the code in the BeforeUpdate event of EventDate control, which I assume is bound to a field in the form's record source query.

Now I am upgrading the database and I have carried numerous developments. Maybe I'll try exporting the form to a different database to see what happens. Wouldn't Access notify me if my query was complex? 0 LVL 44 Overall: Level 44 MS Access 44 Message Expert Comment by:LPurvis2007-02-15 4MB might be too big - I don't P: n/a Edy Chandra Hi, I'm doing a simple application for store.

Home | Invite Peers | More Database Groups Your account is ready. All waffle really - without knowing what your form's rowsource is. 0 Message Author Comment by:dcruz19772007-02-15 I finally got rid of that annoying error. NO ONE HAS THE DB OPEN.