Form Not Functioning . .

[Evagrius]

Hello!

I have a small issue that I need help with. I posted for help on the ExcelForum last week, the link is below, but no one was able to answer my question and a friend recommended this site.

http://www.excelforum.com/access-tables-and-databases/736549-unable-to-add-records-in-form.html

I have a database with one table, one query, and one form. The table has many duplicates. I created a query and a form. In the query I grouped the records so that duplicates will be removed.

However, the form will not allow me to add new records even though I have the edit and add properties of the form set to "YES". If I go back to the query and ungroup the recoreds, then nothing will appear in the form?? I am not sure how to proceed from here.

There are many more fields in the table and in the Form, but due to agency restrictions, I included only a couple in the attachment. Please see the attached and I would be grateful for any help.

 

[namliam]

If you group a query to only show unique records, the query becomes uneditable and thus you cannot add either, no matter what you do on / to the form.

I dont know why your form wont work if you ungroup, I dont have anything but A2002...

Welcome to AWF

 

[Evagrius]

Thank you Namliam - so then this is an Access rule, if you group a query and base a form on that query, you cannot edit / add new records.

How would you recommend I handle this if I must remove duplicates? Thank you!

 

[namliam]

It is not a Access rule, it is a database rule... You take 4 records and make it one, if you edit the one ... which one should the database edit? All perhaps, but that is what relational databases are all about, normalization, meaning take out or remove duplication (as much as possible)

If you have duplicates that need hiding, you either have a design issue (ref: Normalization) or your data is poluted...
You can try a trick with a "In" construct
Select *
from yourtable
where id in (select id from ... *make sure this query contains unique ids that you want to show*)

However if you have duplicated values that need de-duplicating, from accross the web, that smells like a design issue.

 

[Evagrius]

Okay, I think understand. The data in the table is downloaded from a company system - there is little I can do about that part.

Ufortunately, though I am on the road to learning, I am not experienced enought to interpret the second paragraph in you helpful post. I thought maybe I could run the "find Uinque" query wizard, then go back and delete the results from the table. It's a bit tedious but I understand it. Do you see a potential problem with that tactic namliam?

I still would like to find out though why the form trips when I ungroup the data!