Hi all,
I am getting a syntax error when I try to execute this piece of code:
Can anybody help? It probably has to do with separators or parens, but my eyes are tired, I just can't figure it out
Thanks a lot
I am getting a syntax error when I try to execute this piece of code:
Code:
DoCmd.RunSQL "INSERT INTO tblLogins " _
& "(lkpUser, lstAppName, lstLogType, lkpWorkstation, chrPubIP, chrLocIP, chrLogInLocation, chrLoginRegion, chrLoginCountry, chrTimeZone, chrTimeStampUTC, chrSSID) VALUES )" _
& "(" & chrUserLogin & ", 'In', " & chrWorkstation & ", " & chrPublicIP & ", " & chrLocalIP & ", " & chrCurrentGeoLoc & ", " & chrGeoAera & ", " & chrCountry & ", " & lngUtcOffset & ", " & Now() & ", " & chrServiceSet & ");"
Can anybody help? It probably has to do with separators or parens, but my eyes are tired, I just can't figure it out
Thanks a lot