Hi again!
I am stumped again with this VBA-shoot.
Here is what i'd like to do:
1. I put a SQL-statment in a String
strAreas = "SELECT * FROM
WHERE
.[field]
= 'something' AND
.[datefield] = #14/12/00#
2. I want to open a RecordSet
Set rstAreaFields = CurrentDb.OpenRecordset(strAreas)
And here is my problem. I get a "Run-time error '3061'" which says: "Too few parameters. Expected 1."
Has anybody a clue what to do?
thanx!
frag
I am stumped again with this VBA-shoot.
Here is what i'd like to do:
1. I put a SQL-statment in a String
strAreas = "SELECT * FROM
= 'something' AND
2. I want to open a RecordSet
Set rstAreaFields = CurrentDb.OpenRecordset(strAreas)
And here is my problem. I get a "Run-time error '3061'" which says: "Too few parameters. Expected 1."
Has anybody a clue what to do?
thanx!
frag
