Entering data issue

[jordsta95]

Hey there, sorry if this has been asked and answered a million times before. But I had only found one "solution" online, and I didn't understand it at all :/

So anyway, the issue.
I can't enter data into either a main form or the sub-form in it.

Before you ask are the allow edits, etc. enabled, yes they are. And that is why I don't understand why it won't let me enter data.

Is there anything else that could be preventing the data entry?
Because the access "help" message isn't helpful, it isn't giving any sort of error code other than a box saying "Field cannot be updated" when I try to enter data.

 

[pr2-eugin]

See if the JOIN Query you have used is an UPDATABLE query in the first place. Or in other words, see if your Query that is the Recordsource of the Form a Read only. http://allenbrowne.com/ser-61.html

 

[jordsta95]

The only thing I found in that link that MAY be the issue is:
"It has a GROUP BY clause. A Totals query is always read-only."
Now the only reason I say that is because I have a text box with "=[text44]*[Cost]" which works out the total cost of everything on that page... but it also needs to be able to add new records. Am I doing something wrong or did I just misunderstand everything in that link :/

 

[pr2-eugin]

Remove the GROUP BY, then for the control, you can use

= Sum(theFieldYouNeedToUseForCalculation) * Cost

 

[jordsta95]

I don't have a GROUP BY... I thought the Totals query was the "=[number of months]*[Cost]" but I had to look online what a GROUP BY was, as I didn't know what to remove, and I don't have one :/


I'm sure sometimes databases just decide they don't want to work -_-

 

[pr2-eugin]

Can you upload a Stripped DB for us to have a look at?

How to Upload a Stripped DB.

To create a Sample DB (to be uploaded for other users to examine); please follow the steps..

1. Create a backup of the file, before you proceed..
2. Delete all Forms/Queries/Reports that are not in Question (except the ones that are inter-related)
3. Delete auxiliary tables (that are hanging loose with no relationships).
4. If your table has 100,000 records, delete 99,990 records.
5. Replace the sensitive information like Telephone numbers/email with simple UPDATE queries.
6. Perform a 'Compact & Repair' it would have brought the Size down to measly KBs..
7. (If your Post count is less than 10 ZIP the file and) Upload it..

Finally, please include instructions of which Form/Query/Code we need to look at. The preferred Access version would be A2003-A2007 (.mdb files)

 

[jordsta95]

Sorry for the late reply.

The problem is on the "Customer/Server details" form
The problem with it is that it is impossible to add new data in any field

 

[CJ_London]

From what I can see your main form works OK.

The reason your subform is not updateable is because of the number of linked tables - change the Dynaset to Dynaset (Inconsistent Updates)

However it looks like your construct is wrong anyway - for example Game - shouldn't you be updating the GameID field in Server Details? you appear to be trying to update the Game Field in the Game table with the GameID from the Game table

 

[jordsta95]

Thanks CJ, you're a life saver

And I have no idea whether it is supposed to do that or not, all I care about is that it works.
This is just for a section of ICT coursework, and I don't need to implement it. So just as long as it works, then I am happy