Hi All
I am getting this error in one of my VBA SQL codes:
Run Time Error 3352 - No destination field name in INSERT INTO statement (Now())
It occurs on this line:
Code:
CurrentDb.Execute "INSERT INTO FRT_Additionals_Table SELECT FRT_Additionals_Import_Table.Carrier, FRT_Additionals_Import_Table.[20GP BAF], FRT_Additionals_Import_Table.[40GP BAF], FRT_Additionals_Import_Table.[40HC BAF], FRT_Additionals_Import_Table.[20GP GRI], FRT_Additionals_Import_Table.[40GP GRI], FRT_Additionals_Import_Table.[40HC GRI], FRT_Additionals_Import_Table.[20GP PSS], FRT_Additionals_Import_Table.[40GP PSS], FRT_Additionals_Import_Table.[40HC PSS], FRT_Additionals_Import_Table.[20GP MISC], FRT_Additionals_Import_Table.[40GP MISC], FRT_Additionals_Import_Table.[40HC MISC], FRT_Additionals_Import_Table.[Valid From], FRT_Additionals_Import_Table.[Valid To], FRT_Additionals_Import_Table.Notes, Now() FROM FRT_Additionals_Import_Table;", dbFailOnError + dbSeeChanges
Here is the line again with line breaks for easier reading:
Code:
CurrentDb.Execute
"INSERT INTO FRT_Additionals_Table
SELECT FRT_Additionals_Import_Table.Carrier,
FRT_Additionals_Import_Table.[20GP BAF],
FRT_Additionals_Import_Table.[40GP BAF],
FRT_Additionals_Import_Table.[40HC BAF],
FRT_Additionals_Import_Table.[20GP GRI],
FRT_Additionals_Import_Table.[40GP GRI],
FRT_Additionals_Import_Table.[40HC GRI],
FRT_Additionals_Import_Table.[20GP PSS],
FRT_Additionals_Import_Table.[40GP PSS],
FRT_Additionals_Import_Table.[40HC PSS],
FRT_Additionals_Import_Table.[20GP MISC],
FRT_Additionals_Import_Table.[40GP MISC],
FRT_Additionals_Import_Table.[40HC MISC],
FRT_Additionals_Import_Table.[Valid From],
FRT_Additionals_Import_Table.[Valid To],
FRT_Additionals_Import_Table.Notes,
Now()
FROM FRT_Additionals_Import_Table;", dbFailOnError + dbSeeChanges
The Now() is a timestamp for when this code runs, it goes into the "Lastmodified" field in FRT_Additionals_Table.
As far as I can tell it should work and line up, pics below of both tables structure:
Any help would be greatly appreciated.