Receive Syntax Error in simple query. Looks good to me.

[tmartin]

I am unable to delete a record from a Table. I get an error


"Syntax Error in query. Incomplete query clause"
The value of SqlSyntax shown in the messagebox is

DELETE FROM 'Daily Turn' WHERE DailyTurnID = 4796

I do not see anything wrong with this query. There is a relationship to two other
tables but the "Enforce ..." not not selected. Any ideas?



Dim tblName As String
tblName = "Daily Turn"
Const cstrPrompt As String = _
"Are you sure you want to delete this record? Yes/No"

If MsgBox(cstrPrompt, vbQuestion + vbYesNo) = vbYes Then
MsgBox "DailyTurnID = " & Me.DailyTurnID
SqlSyntax = "DELETE FROM '" & tblName & "' WHERE DailyTurnID = " & Me.DailyTurnID
MsgBox SqlSyntax
CurrentDb.Execute SqlSyntax
Call btnReturn_Click
Else 'user clicked no
MsgBox "Deletion was aborted.", vbInformation
End If

[June7]

Replace the apostrophes with []. Use [] to delimit object names that have spaces and special characters/punctuation (underscore is exception) or are reserved words. Recommend avoiding those in naming convention.

[orange]

I do not see anything wrong with this query. There is a relationship to two other
tables but the "Enforce ..." not not selected. Any ideas?

Here's a link to Access SQL that may help

You should also use code tags when showing/posting any code.
Highlight the code then click on the # above this posting window.

Good luck with your project.