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

    Please help with this Easy Question

    I even tryed to change the insert statement around to this.... sSql = "INSERT INTO DEPENDENTS(DEPEND_ID, DEPEND_ASSOC_ID, DEPEND_FNAME,DEPEND_LNAME, DEPEND_DOB, DEPEND_AGE, DEPEND_RELATE_TYP) VALUES ('" & cboAssociate2.Value & "','" & cboAssociate2.Value & "', '" & txtFirstName.Value & "', '"...
  2. sksbizkit

    INSERTING into a Table please help

    The insert portion is pulling the right info...its just throwing that into the table is not executing
  3. sksbizkit

    INSERTING into a Table please help

    So i have a form with combo boxs,textboxes...and i want those values inserted in a table called "DEPENDENTS". here is the code i have, but its just not inserting the values... Private Sub cmdAddDependent_Click() Dim sSql As String Dim dbThis As Database ' Set dbThis = Access.CurrentDb sSql =...
  4. sksbizkit

    INSERTING into a table

    So i have a form with combo boxs,textboxes...and i want those values inserted in a table called "DEPENDENTS". here is the code i have, but its just not inserting the values... Private Sub cmdAddDependent_Click() Dim sSql As String Dim dbThis As Database ' Set dbThis = Access.CurrentDb sSql =...
  5. sksbizkit

    PLEASE HELP...easy question

    All that i'm trying to do is INSERT values from a form into a table called "DEPENDENTS" using access/sql...its just not updating my table...here is the code..PLEASE HELP Private Sub cmdAddDependent_Click() Dim sSql As String Dim dbThis As Database ' Set dbThis = Access.CurrentDb sSql =...
  6. sksbizkit

    Please help with this Easy Question

    changed my code to this, and it still doesnt update my table... Private Sub cmdAddDependent_Click() Dim sSql As String Dim dbThis As Database ' Set dbThis = Access.CurrentDb sSql = "INSERT INTO DEPENDENTS VALUES('" & cboAssociate2.Value & "','" & cboAssociate2.Value & "', '" &...
  7. sksbizkit

    Please help with this Easy Question

    All that i'm trying to do is INSERT values from a form into a table called "DEPENDENTS" using access/sql...here is the code..PLEASE HELP Private Sub cmdAddDependent_Click() Dim sSql As String Dim dbThis As Database ' Set dbThis = Access.CurrentDb sSql = "INSERT INTO DEPENDENTS VALUES('" &...
  8. sksbizkit

    Diplaying info in a TextBox from a Query using a ComboBox

    So i have a Combo Box that displays all employees from "Query1" on "Form1" and within that "Query1" is fields "Birthdate","Emp_id","Emp_Name". I also have a textbox on that "Form1". I have the combo box displaying all the employees fine, but what i want to do is when you select a employee from...
  9. sksbizkit

    referencing table.field in query by design

    Hey everybody i'm trying to reference a table field directly in a query by design with this code: [mytable]![myfield] there is only one row and will always be one row. Can this work??

Part and Inventory Search

Back
Top