Problem with OpenRecordSet in Access!
Problem with OpenRecordSet in Access!
(OP)
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 [table] WHERE [table].[field]
= 'something' AND [table].[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 [table] WHERE [table].[field]
= 'something' AND [table].[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
RE: Problem with OpenRecordSet in Access!
just forget this thread! i did a typical rookie-mistake with the sql-string in my code!
sorry
frag