Search results

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 :)

Ok, I did and I've found: SELECT FROM [Anagrafica Aziende];

so may I substitute again? [Anagrafica Aziende] instead of Denominazione after .me ?

all what I found is: SELECT FROM [Anagrafica Aziende];

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

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...

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).

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.

The reason that why I decided to try to violate a constraint is that, who projected this database set the primary key on the Denominazione field, but I don't want it to persist because of the fact that I prefer allow inserting duplicates in case of omonimy. So I have removed the primary key...

Situation doesn't chance if I clear the code. I cannot duplicate data, in both cases (neither with the code nor without). I add that Denominazione field is not indexed on the table Anagrafica Aziende.

Ok, I did. Now I cannot duplicate terms. What is absurd is the fact I receive an error message (I am trying to duplicate data in primary key, or in index or in ?relation?), and not a warning in english. The Denominazione field WAS primary key, but I decided to change the field in which to...

Here it is the pic of the window where I pasted VBA code. I took the screenshot after the debug.

Hi CJ_London, thx for the message. Now it's clearer, I can say that the terms you told me to substitute are correct. I send you a pic to show you where I go, and what I do to try to make debug. I only click on the first line (orange) where it's written "Compila prova contatti"; after I have...

about the code: what I've understood up to now, is that the two if(s) are used to build a logical condition to discern if it's the case to show the warning message to the user which is inserting a data to the Denominazione field. Before the if(s) there is a select command in which are taken all...

The DMBS lets the user add duplicate names. I say that to try to answer your question: does it still update if the user doesn't say yes? or doesn't update? Do you get an error message? no error messages are displayed then.

Later I try to let you know what I have understood about the code fragment you sent me: dim rst as recordset set rst = currentdb.OpenRecordset("SELECT * FROM [Anagrafica Aziende] WHERE Denominazione='" & me.[AggiungiAzienda.Denominazione] & "'") if not rst.EOF then 'there is a duplicate if...

First thing I can tell you are these: don't take into consideration what I told you about the message in italian, it was a misunderstanding.

OK, thanks a lot for the encouragement. Now I try to think about the questions you have let to me to help me. Once I have a sensible answer I contact you. p.s. congratulations for your italian. :)

You are right, I didn't go on, because of the shame. Excuse me,now I have to go home, and take a deep breath, As soon as I can I try to contact you again. Thx for all, with heart.

No no, it's sad to say, but it doesn't work... sob...