Search results for query: *

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 & "', '"...

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

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

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

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

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 & "', '" &...

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('" &...

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

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