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

syntax problem

P: 12

I am getting a syntax error saying: too few parameters expected one.

This is the code that i have been trying:

CurrentDb.Execute "UPDATE tblitem SET IsSelected = True WHERE itemID = '" & cboItemID & "'"

Would anyone know what the problem could be, the field is alphanumeric
Feb 20 '08 #1
Share this Question
Share on Google+
5 Replies

P: 12
Not to worry, i have resolved this issue....
Feb 20 '08 #2

Expert Mod 15k+
P: 31,769
It would be nice to see your solution. It may help others with similar problems in future.
Feb 21 '08 #3

P: 12
The problem was,
The field IsSelected in my table was stored as selected only and therefore this error is occuring, also the piece of code "'" is used for alphanumeric fields.

So i finally worked out....Hope this helps
Feb 21 '08 #4

Expert Mod 15k+
P: 31,769
It does - thank you.
I guess the ItemID was actually numeric then.
Feb 22 '08 #5

P: 12
thats right...........................
Feb 23 '08 #6

Post your reply

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