MS VBA Access: How to Delete "One" Record in a Table?

Question

I keep getting this error: "Syntax Error In From Clause."

The below is my code. Could someone help.

Private Sub Command26_Click()

DoCmd.RunSQL "DELETE * " & _

"FROM Budget_Planner_SubDatasheet" & _

"CompanyStore = 'Begining Balance';"

Answer 1

Private Sub Command26_Click()

DoCmd.RunSQL "DELETE * " & _

"FROM Budget_Planner_SubDatasheet " & _

                                   ;            Ã‚ Â Â Â Â Â Â Â Â Â   ^

"WHERE CompanyStore = 'Begining Balance';"

You need a space after SubData Sheet and the WHERE keyword in the criteria clause

Answer 2

Software Engineering Tools-

http://smartertols.com/