Search results

Ok, it works!!! I am deeply grateful to you! The only thing I cannot understant, is why the DBMS sends me a warning in italian, and not in english as it is in the conde. Actually I thought the output was as the following string: "this name already exists, do you still want to save it?"

If I compile, I receive an error message: not unique name detected, at this point of the code: Private Sub Form_BeforeUpdate(Cancel As Integer)

I guess it isn't, i think it is Anagrafica Aziende, but I am not sure because the name of that property is translated in my language in a way I cannot be sure of what I'm saying, and I'm making a mess.

Ok, now it works, I only had to clos and reopen my database.

I try to describe you better the situation by sending you a detail of the structure of the table called Anagrafica Aziende.

I've done an error when describing you the situation. I try to explain: the field Denominazione is not indexed, but I would to index it, by imposing Yes, and adding duplicates not allowed, unfortunately, when I try to select it the DBMS doesn't allow me to.

I have overwritten: Set rst = CurrentDb.OpenRecordset("SELECT * FROM Anagrafica Aziende WHERE Denominazione='" & AggiungiAzienda.Denominazione & "'")

error message: attended expression

I guess, I am debugging: I had this string (in red) in output: OpenRecordset("SELECT * FROM Anagrafica Aziende WHERE Denominazione=" & AggiungiAzienda.Denominazione &) and an error message saying some thing like: attended... (cannot remember sorry)

I'm sorry, I went to the library to get a book (authors: Viescas and Conrad), I have just come back, now I read your lasts posts.

maybe I don't understand what you mean by "the name of the control on your form", so I am not sure about what I want to overwrite there. I confirm that the field Denomination is text.

Ok, I'have read as much carefully as I can all your tip, and I have a pair of things to ask you: - are the red myField and the green myField the same word? (I hope). - (silly) do I have to search info about debugging on the web? (I guess).

Ok, I want to try right now. I guess it's a really detailed explanation, I will let you know anyway then...

Great, thank you for the tip, it's clear. I take a look to the links you suggested me, and I start learning.

Hi CJ_London thank you, really. You helped me to understand that I cannot violate a constraint, and that if I knew VBA I would had a powerfull instrument to control the DBMS. Currently I'm studying SQL syntax, but I'd like to learn VBA too, can you tell me which level of knowledge I have to...

I have a table in which I must enter informations about companies (Denomination, address, telephone...). I would create a field called Denomination, in which to enter the names of the companies. I need to be able to control and avoid the fact that a name could be entered more than once, for...

You're really nice, I take a look at the tutorial you suggested me. Thx.

I do thank you. So you confirm what I suspected: I must necessarily make a query if I want to perform a "filter" that involves more than a table; the perplexity I had was due to the fact that my boss asked me to try to perform the same operation, not by making a query, but just using the filter...

Thx a lot for the answer. I try to explain better (i'm not mothertongue). The database of which I'm talking to collects informations about companies (name, phone, address...). In the first table of the database there's a filed called Sector, used to save the information about the sector in...

Hi I'm a newbie with Access, so my question may be silly. I've been asked to try to propagate a filter result on all the tables on a database. Hence I'm trying to know if the action of a filter works on a single table only, or if it can work on more than one. Can anyone help me? Thx a lot.