Runtime ERROR 3134

D

DS

I'm using this SQL phrase that is working on Several forms, but n one
form I keep getting he dreaded 3134 Error. Any help appreciated.
Thanks
DS

Me.TxtTableID = Nz(DMax("[TableID]", "PCenter"), 0) + 1
Dim SectionSQL As String
DoCmd.SetWarnings False
SectionSQL = "INSERT INTO PCenter
(TableID,SectionID,TableName,TTypeID,Active)" & _
"Values(" & Forms!Easy12!TxtTableID & "," &
Forms!Easy12!TxtSectionID & " " & _
"'" & Forms!Easy12!TxtTableName & "'," & Forms!Easy12!TxtType & ","
& Forms!Easy12![ChkActive] & ")"
DoCmd.RunSQL (SectionSQL)
DoCmd.SetWarnings True
Me.ListTables.Requery
 
S

Steve Schapel

DS,

Looks like you are missing a comma between Forms!Easy12!TxtSectionID and
Forms!Easy12!TxtTableName.
 
D

DS

Steve said:
DS,

Looks like you are missing a comma between Forms!Easy12!TxtSectionID and
Forms!Easy12!TxtTableName.
Your're absolutly right! Sometimes you can't see the forrest for the
trees. Thats what I get for working so hard!!!
Thanks, Steve
DS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Problem 2
Complex If Statement 6
SQL Percent Problem 2
runtime error-2113, please help 2
Code Is Slow 3
Code Is Slow 6
run-time error 3201 8
Runtime Error 2107 3

Top