Insert into

[sovereign]

Afternoon,

So I have some code that was working but now seems to show Syntax Error.

If someone could help would be really helpful

Dim workreq As String
workreq = "N/S/F: " & Me!Text771 & "mm," & "O/S/F: " & Me!Text782 & "mm," & "N/S/R: " & Me!Text785 & "mm," & "O/S/R: " & Me!Text788 & "mm," & "Spare: " & Me!Text791 & "mm"
jetsql = "INSERT INTO fleet_Maintenance (Fc, FMx, FMmileage,) VALUES ('" & Me.txtFC & "', 'Check Sheet Completed test' & vbCrLf & workreq & vbCrLf & Me.Other & " ', '" & Me.txtFMmileage & "');"
CurrentDb.Execute jetsql, dbSeeChanges  'dbSQLPassThrough

Fc is a number as is me.txtFC
FMx is text and numbers


FMmileage is numbers

im sure its so simple but I just cant seem to find it

Regards

[ranman256]

If mileage is a number, why did you quote it?

[orange]

When creating SQL within vba, create a string variable. Then, assign your "SQL" to that string.
Then, insert a Debug.print yourSQLvariableName to output the SQL that Access has rendered to the immediate window. It will show any syntax errors.

eg.

Dim sSQL as string
sSQL =  "INSERT INTO fleet_Maintenance (Fc, FMx, FMmileage,) VALUES ('" & Me.txtFC & "', 'Check Sheet Completed test' & vbCrLf & workreq & vbCrLf & Me.Other & " ', '" & Me.txtFMmileage & "');"

Debug.Print sSQL
....

I you don't know how to get to the immediate window,hit Ctrl G and view immediate window

[sovereign]

was trying to remember that debug.print code so simple but forgot it!

Got it perfect thanks for all your help again