Access 2003 VBA SQL "Too few parameters" error

Question

Dim sort_slots_sql As String
sort_slots_sql = _
    "select date, part, service, slot" & _
    " from ass_slots, ass_occasions" & _
    " where ass_slots.occasion = ass_occasions.occasion" & _
    " order by slot, service, date, part"
Set slots_rst = db.OpenRecordset(sort_slots_sql)

This gives a too few parameters error. One is expected. On another place in the code, there is an almost identical situation but there, two parameters are expected!

JohnFx · Accepted Answer · 2012-01-09 21:21:34Z

5

I can't say conclusively, but I am 99% sure the problem is that you have included a field name in that query that doesn't exist in the table. Check all the fields names and make sure they are spelled exactly like they are in the table.

Also the "Date" field is a likely suspect since it is a reserved word in Access. I'd suggest not naming a field "Date". However, if you are stuck with that name, surround it with square brackets in all your queries like so:

Dim sort_slots_sql As String
sort_slots_sql = _
    "select [date], part, service, slot" & _
    " from ass_slots, ass_occasions" & _
    " where ass_slots.occasion = ass_occasions.occasion" & _
    " order by slot, service, [date], part"
Set slots_rst = db.OpenRecordset(sort_slots_sql)

answered Jan 9, 2012 at 21:21

JohnFx

35k19 gold badges108 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Emanuel Berg Over a year ago

Correct, in one of the tables a column was named "datum" (Swedish for date). Thanks a lot!

JohnFx Over a year ago

You bet. Seen that error a million times. Good luck with your app.

onedaywhen Over a year ago

Wow you have seen a lot of errors. Have you ever seen the one about "Too many double entendres" ? ;)

Fionnuala Over a year ago

@onedaywhen Err number 69, perhaps?

Collectives™ on Stack Overflow

Access 2003 VBA SQL "Too few parameters" error

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related