Please help with this Easy Question

[sksbizkit]

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('" & cboAssociate2.Value & "','" & cboAssociate2.Value & "', '" & txtFirstName.Value & "', '" & txtLastName.Value & "', '" & txtB.Value & "'," & txtNumber.Value & ")"



Dim cQry As QueryDef
Set cQry = dbThis.QueryDefs("TEMP", sSql)
cQry.Execute


End Sub

 

[PHV]

Why using a QueryDef for an action query ?
You may try either this:
DoCmd.RunSQL sSql
or this:
dbThis.Execute sSql

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sksbizkit]

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 & "', '" & txtFirstName.Value & "', '" & txtLastName.Value & "', '" & txtB.Value & "'," & txtNumber.Value & ",15)"


dbThis.Execute sSql




End Sub

 

[PHV]

What are ALL the fields (name+datatype) of DEPENDENTS ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sksbizkit]

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 & "', '" & txtLastName.Value & "', '" & txtB.Value & "'," & txtNumber.Value & ",15)

 

[PHV]

Replace this:
dbThis.Execute sSql
with this:
Debug.Print sSql

Then copy the ouput produced in the debug window and paste it in the SQL view pane of a brand new query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lespaul]

sksbizkit - Do you think by posting the same question 3 different times you're adding any value to this site or your learning process? You don't even change the question any to make it different in any way....

Thread701-1330801 posted 10:40
Thread701-1330808 posted 10:57




Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins