Improve company productivity with a Business Account.Sign Up

x
?
Solved

Why will the set not update?

Posted on 2015-02-09
3
Medium Priority
?
74 Views
Last Modified: 2015-02-12
The record set in the attached will not update. It has a promary key and was updating until today. The form in question only pulls from one table.
Database55.zip
0
Comment
Question by:cssc1
  • 2
3 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 40599798
Your Source for the form is a Group By Query.
By their very nature as "summary" queries, Group By queries are not update-able.

You will have to create a form based on the source table directly and update that.

JeffCoachman
0
 

Author Closing Comment

by:cssc1
ID: 40605523
Thank you
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40605682
In looking closely at your query...
All of the fields are "Group By"...
What this means that it is basically the same as the table. (except being non-updateable.)
So my guess as to why it worked before is that someone may have inadvertently hit the "Totals" button in design view.
The query looked the same, so they may not have noticed.

So if you just "un-hit" the "Totals" button, the query should revert back to an update-able query,
Give it a try...
;-)
Totals Button
Jeff
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Implementing simple internal controls in the Microsoft Access application.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

585 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question