By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
463,098 Members | 695 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 463,098 IT Pros & Developers. It's quick & easy.

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

P: 2
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';"
Aug 18 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 112
You are not signifying your where clause as a where clause it should read:

Expand|Select|Wrap|Line Numbers
  1. DoCmd.RunSQL "DELETE * FROM Budget_Planner_SubDatasheet WHERE CompanyStore = 'Begining Balance';"
Aug 18 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.