Too Few Parameters?

[HandJT]

I have a code where when executed an error of too few parameters in the following sql command pops up:

Set rs = db.openrecordset("Select * " & _
"FROM Plant_Employees " & _
"WHERE Plant_Employees.[clock#] = " & val(clock.value))

Is there something I am missing? Any suggestions? If you need more information, Let me know.

Thanks in advance!!

 

[PHV]

No spelling issue with [clock#] ?
It's the real name of a field in the Plant_Employees table ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[KenReay]

Hi

Check you SQL for spelling errors are you sure you have column names spelt correctly

also try

Set rs = db.openrecordset("Select * " & _
"FROM Plant_Employees " & _
"WHERE Plant_Employees.[clock#] = " & val(clock.value)
& ";")



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[HandJT]

See, that is what is weird. I do have it all spelled right. But I will try to use what KenReay suggested and see if that works. I'll let you know. Thanks a million!

 

[HandJT]

Sorry KenReay, it didn't work. Any other suggestions?

 

[KenReay]

Like PHV I am suspicious of Clpck# as a column name

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[HandJT]

In what regards? I mean, I use to have the column named Clock # with a space, but was having problems. I then changed it to clock# with no space and have had no problems with it so far. You think maybe I should change it and if so what are my name options for clock#?

 

[KenReay]

Take out the special character (#) use (say) ClockNo

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[HandJT]

Sorry, but I found my problem. Even though I changed the Clock# by taking out the space in the form and code, I forgot to take it out in the table (DUH!!). Thanks for trying to help though!!