simongallop
Registered User.
- Local time
- Today, 00:58
- Joined
- Oct 17, 2000
- Messages
- 611
Am using code to open a query to see if any records exist. At the Set MyRS = currentdb.openrecordset..etc I am getting Run time Error 3061: Too few parameters Expected 1:
When I go into help it says:"This parameter query requires the specified number of parameters, which you didn't supply. Provide the expected number of parameters, and run the query again.
In some cases, this message is generated when unknown field names or expressions are interpreted as query parameters. Be sure to enclose field names containing spaces or punctuation with square brackets [ ]. "
The query is very simple:SELECT ED, TAG
FROM prmOutput
WHERE ((prmOutput.ED)<[Forms]![DelDate]![txtDelDate]);
Can anyone shed any light as to how to get around this problem.
What I am trying to do is to see if any records exist that are older than the date on the form. Though that by creating a query which would show these records and if the query returned records then do one thing and if it was empty do something else but I am being thwarted at the Set query to Recordset variable point!
Thanks in advance
When I go into help it says:"This parameter query requires the specified number of parameters, which you didn't supply. Provide the expected number of parameters, and run the query again.
In some cases, this message is generated when unknown field names or expressions are interpreted as query parameters. Be sure to enclose field names containing spaces or punctuation with square brackets [ ]. "
The query is very simple:SELECT ED, TAG
FROM prmOutput
WHERE ((prmOutput.ED)<[Forms]![DelDate]![txtDelDate]);
Can anyone shed any light as to how to get around this problem.
What I am trying to do is to see if any records exist that are older than the date on the form. Though that by creating a query which would show these records and if the query returned records then do one thing and if it was empty do something else but I am being thwarted at the Set query to Recordset variable point!
Thanks in advance
