Search results for query: *

No I didn't. And the ListBox rowsource is this: SELECT Kide.Codigokide, Kide.Nombrekide FROM Kide ORDER BY [Codigokide];

ERROR 7777 YOU USE INCORRECTLY LISTINDEX Yesterday this code works, but today no, I don't understand For j = 0 To cad.ListCount - 1 If cad.Column(1, j) = Me.Lista3.Column(0, 1) Then cad.SetFocus cad.ListIndex = j Exit For End If Next

This is the Listbox rowsource SELECT Kide.Codigokide, Kide.Nombrekide FROM Kide ORDER BY [Codigokide];

I want to put selected one value in cad ListBox, It says me that I use incorrectly the ListIndex I have this code: For j = 0 To cad.ListCount If cad.Column(1, j) = Me.Lista3.Column(0, 1) Then cad.ListIndex = j End If Next

I want to put a SQL query result in a textbox but I don't know how. in Access strSQL = "SELECT NombreProyecto " strSQL = strSQL & "FROM Proyecto " strSQL = strSQL & "WHERE [CodigoProyecto]="& OpenArgs & "" And then... The query result is only one file Thank you

How can I get if a check box is checked or no with VBA code? Thanks

How can I know if a SELECT return some information or it doesn't return any results, in VBA

I have this code: Private Sub codProyecto_Change() Dim strSQL As String strSQL = "SELECT *" strSQL = strSQL & "FROM Proyecto " strSQL = strSQL & "WHERE [Nombre proyecto]='" & codProyecto.Text & "'" Me.lstResultado.RowSource = strSQL End Sub This code take a name for a...

how can I input an autonumerical (incremental) number in a Data Base with VBA? I don't know how to write the INSERT INTO sentence I don't know if I'm explaining. table(ID,Name) the ID is primary key and incremental

Thank you for your help, but nw I have another problem, how can I input an autonumerical (incremental) number? I don't know if I'm explaining. table(ID,Name) the ID is primary key and incremental

I want to insert data in my DataBase (in acces) with VBA. How can I do it? I have an autonumerical field and I don't know how to excute a INSERT INTO command in VBA. Thanks