• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Forms won't update table or querries (1 Viewer)

B

billmorr

Guest
The only way I can add a record or update an existing record is in the table datasheet view. If I try to add or update a record in form view or querry datasheet view the message, "this recordset is not updateable" appears. I might have inadvertantly chaged something while creating calculated fields in a querry, but cannot find any problem. The calculated fields work ok.

I have the form properties set as follows: Allow Edits Yes
Allow Deletilons Yes
Data Entry Yes
Recordset Type Dynaset
Record Locks No Locks
Any help will be appreciated.

Bill
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 08:12
Joined
Feb 19, 2002
Messages
29,771
Queries that use aggregate functions - sum, count, group by, etc. are not updateable.

If the calculation in the query operates only on data from a single row (for example you are dividing columnA by columnB), then all fields except the calculated one will be updateable. In this case if you want to update the underlying values, you will need to include them in the select. For example:
Select ColumnA, ColumnB, ColumnA/ColumnB as CalcColumn .....
 

Users who are viewing this thread

Top Bottom