error 3134

A

Alain

Hi,
Can anyone help me on this syntax error 3134 Syntax Error in INSERT INTO
statement
Idxxxx are numeric, PropOther is a string and everything else is checkboxes

CurrentDb.Execute _
"INSERT INTO [tblLease]
(IdProperty,IDBusinessGroup,IDDivision,IDPropertyType,Surplus)" & _
"(Lease3rdParty,NonManuf,PropOther,Corpo,BA,EP,PM,FEU,FAM,FAS,GB,GPH,GT,PACK)
" & _
"VALUES('" & Me.IdProperty & "','" & Me.IdBusinessGroup & "','" &
Me.IdDivision & "')" & _
"('" & Me.IdType & "','" & Me.Surplus & "','" & Me.Lease3rdParty &
"','" & Me.NonManufacturing & "')" & _
"('" & Me.PropOther & "','" & Me.Corpo & "','" & Me.BA & "','" & Me.EP
& "','" & Me.PM & "')" & _
"('" & Me.FEU & "','" & Me.FAM & "','" & Me.FAS & "','" & Me.GB &
"','" & Me.GPH & "','" & Me.GT & "','" & Me.PACK & "')", dbFailOnError


TIA

Alain
 

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


Top