How to violate a constraint?

[CJ_London]

Just because you have removed the primary key does not mean that duplicates are allowed - check your table design to ensure the field indexed yes - duplicates allowed.

The message you were getting in italian is generated by the system because this setting was not allowing duplicates

Have you tried manually adding a duplicate directly in the table to see what happens?

 

[iaccess14]

I send you a pic showing a detail of the properties of Denominazione field. Where "indicizzato" I choose No (where options are: No, Yes allow duplicates, Yes don't allow duplicates). But I still can duplicate without having a warning.

 

[iaccess14]

When I go to paste the code I'm asked to choose between three options I go on 'code generator' (and not on 'macro' or the other).

 

[CJ_London]

can you also send me the recordsource for your form - just need to check what you are updating

 

[iaccess14]

What do you mean by 'recordsource'? If I can I send you, that's for sure. I'm sorry I try to understand by myself...

 

[iaccess14]

When I try to open 'recordsource', it asks me if I want to create new...

 

[iaccess14]

all what I found is:

SELECT 
FROM [Anagrafica Aziende];

 

[iaccess14]

so may I substitute again?

[Anagrafica Aziende] instead of Denominazione after .me

?

 

[CJ_London]

Form recordsource - go to form design

Then click on the 3 dot carat to the right to open the query builder

then click on the view button and select SQL

Then copy the SQL code and paste it into your post

 

[iaccess14]

Ok, I did and I've found:

SELECT 
FROM [Anagrafica Aziende];

 

[CJ_London]

OK - better send my your db.

compact the database first, then zip it up and then upload

 

[iaccess14]

Hi CJ_London,
I am here again to thank you: the code you sent me works perfectly indeed.
The problem was due to the fact that I had not enabled macros; it took me just eleven days to understand it. Wow!

So thx again, really.

Bye