siu17

i need a code to enter data into a textbox and update an access database table which must be displayed in my listbox, please help i also want to know hoe to search data in the table

I have been trying the following code for a code to search for a record and display it in a textbox Option Explicit Dim conn As ADODB.Connection, rec1 As ADODB.Recordset Dim esql1 As String Private Sub Form_Load() Set conn = New ADODB.Connection Set rec1 = New ADODB.Recordset conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data …

hi i have been able to update a database using the following code Option Explicit Dim conn As ADODB.Connection, rec1 As ADODB.Recordset Dim esql1 As String Private Sub Command1_Click() On Error GoTo 2 If Text1 = "" Then Command1.Visible = False Command2.Visible = True Exit Sub End If rec1.AddNew rec1.Fields(1) …

if you put radio/option buttons in one frame then only one can be active, you should use the checkbox for that for an option button the property is option1.value= true/false

Hi I need the code in [COLOR="Red"]VB6[/COLOR] to display data from a database in a listbox i tried the following code but its not working Do While Not rec2.EOF List1.ItemData(List6.NewIndex) = rec2.Fields(4) rec2.MoveNext ' i even tried Do While Not rec2.EOF List1.ItemData rec2.Fields(4) rec2.MoveNext