Set Command (Access SR2)

Topic

New Reply

I am creating a recordset using the set command below in an ON format in a report:

Set rst = mydb.OpenRecordset(“combined gen med by Dept”)

In the Combined gen med by dept query, I have a parameter requesting the date. I only want to extract certain information. I am prompt and I enter in the date and then I get an error message stating too few parameters.

Any suggestions???

Thanks,
Deborah

Reply | Quote

Replies

Here’s my …
A few of suggestions for you to try:
1) You may want to use a query name without spaces. It simplifies things greatly!
2) Although it’s an optional argument, I would include the TYPE argument of the OpenRecordset method (i.e. dbOpenSnapshot or dbOpenDynaset).
3) If those don’t work, try posting the SQL of your query here. Maybe someone will be able to spot the problem from that.

HTH

Reply | Quote