Recent content by meme'1992

Thanks! I don't know very well how it works! =) Can you suggest me a way to don't write in my record and only read this value? Thanks a lot

Thanks! Yes, my combobox is connect with the field. I want that my defaul value is null. Then when i click on the combobox i can choose my value and select what i want. And i notice that it write in my record

Hello! I create a combobox in a form. With this i select a value "Nome" from table "People", which I insert in a table "Vote". But the combobox, when i select overwrite the first record of "People". Then, I want that at the load i don't see the first element but i want it null, and then when I...

Yes, the columns are 3. How can assign to each colomn the value? I make a select and a recordset. Can I use fields of recordeset?

Relsove! I use Me.lista_persone.Value and works!!!

Hi, I have a listbox , fill with a select. I want to select a value in the listbox and pass in another select. Private Sub lista_persone_Click() Dim tmpR As DAO.Recordset Set tmpR = CurrentDb.OpenRecordset("SELECT Exam FROM Exam WHERE NAME_PERSON = '" & Me.lista_persone.Selected & "' ")...

Thanks! If I want create a listbox with 3 column (nameperson, surname,exam), how can I do?

Thanks. It works!!

In the debug of a vba form, i have this error "mismatched data types in the criterion expression" Private Sub btn_find_Click() Dim tmpRS As DAO.Recordset Set tmpRS = CurrentDb.OpenRecordset(" SELECT name FROM Person WHERE [Surname]= '" & Me.txt_Surname & "' AND [Date] = '" & Me.txt_Date...

IT WORKS!! Thank you very much!!!

in this way tmpRS.RecordCount is 0, and doesn't make the for.

THanks. I try to insert in the for movenext after the additem, but I see only the second record. It doesn't save the first record

Hi, i have two table: Person and exam. The relation is 1:n. I want to see in a listbox all the exam of that person. so I write in vba: Private Sub btn_find() Dim tmpRS As DAO.Recordset Set tmpRS = CurrentDb.OpenRecordset("SELECT exam FROM exam WHERE name = '" & Me.txt_name & "' ") Dim i...

Hello, I have two table. A person (table1) make more exame (table2). This is a relation 1:n (table1:table2). Table1: ID_1, name Table2: ID_2, exame , ID_1 I create a mask in which i want to insert the data of table1 and table2. With a button I save them. Table1: ID_1, NOME ---> id insert...