syntax correction needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The syntax for the following is not quite correct.
Dim lngPeoID as integer
Dim sSQL as String

Access complains about syntax for both of the following versions of an SQL stmt (with and without {[])
sSQL = "Insert into tblVersion ([peoPeopleID] Values (" & lngPeoID & ")"
sSQL = "Insert into tblVersion (peoPeopleID Values (" & lngPeoID & ")"
 
Hi,
You're not closing the first (
sSQL = "Insert into tblVersion (peoPeopleID) Values (" & lngPeoID & ")"
 
Thanks. I had taken the paren as belonging to the whole statement.
It still doesn't come out even. I need to remember my days of counting parens in programs.
 
Back
Top