Access 2003 VBA SQL "Too few parameters" error
    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!
Access 2003 VBA SQL "Too few parameters" error
===

    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!