Search results for query: *

strX = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & cdlOpen.FileName & ";Persist Security Info=False" SelectString = "SELECT * FROM Subscribers WHERE " & lstQuery.List(lstQuery.ListIndex) & " = '" & txtQuery.Text & "'" TableCreate =...

My problem isn't really with the Insert statement so much as how to get my point across to VB :) I'm not sure if I should use an ADODB.Connection, ADODB.Recordset, ADODB.Command, etc. And after I Dim my variable as one of the above, would it be easier to use .Open, .Execute, etc. to send the...

Thanks for the suggestions, guys. Turns out that I needed to set DataGrid1.DataSource to null in the properties and declare it to be ADODC1 at run time. :) It's always the simple stuff you don't think of. --CharonErebus

What I'm trying to do is query an MS Access database and display all the results in a datagrid. That part is working fine, but I also want to insert the results into a table to keep separately from the original table. I'm having trouble with my SQL statement and keep getting errors. What I...

As far as I can tell, I don't use the ADODC before I provide the ConnectionString. It is the first thing in the Form_load() event. Here is the code I'm using to make the connection: 'This is in the general declarations Dim strX As String Dim rstX As New ADODB.Recordset 'Here is the...

I am working with Visual Basic 6.0 and Access 2000. I am using ADODC to connect my program to the Access database. As it stands now, I have the ConnectionString property set at design time to a default database and at runtime open a common dialog box and change the connection to the database...

Thanks a bunch...that's exactly what I needed to know.

I am an almost complete newbie to Visual Basic and I'm having a problem with the Microsoft Jet 4.0. I am trying to create a program to manage a database of newspaper subscribers stored in a microsoft access .mdb file. I am programming mainly on a Windows 2000 professional computer with Access...