Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CharonErebus

    SQL INSERT statement in VB

    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 =...
  2. CharonErebus

    SQL INSERT statement in VB

    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...
  3. CharonErebus

    ADODC Connection problem

    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
  4. CharonErebus

    SQL INSERT statement in VB

    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...
  5. CharonErebus

    ADODC Connection problem

    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...
  6. CharonErebus

    ADODC Connection problem

    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...
  7. CharonErebus

    Newbie question regarding Microsoft Jet 4.0

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

    Newbie question regarding Microsoft Jet 4.0

    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...

Part and Inventory Search

Back
Top