OpenRecordset ic confusing

[Fireman1143]

With the following code I get a message of "too few parameters expecting 1" and also at another section it says I have one too many )



sql="SELECT * FROM tblInput WHERE (((month([InputDate])) = " & f!month &" AND ((Year([InputDate])) = " & f!year & "0" &' And ((EmployeeID) = " & f!EmployeeID & &quot)) ORDER BY InputDate;"

Set db = CurrentDB()

Set rs = db.OpenRecordset(sql, dbOpenSnapshot)


As I am just beginning using VB I am not sure of the proper syntax of OpenRecordset.

Fireman1143

 

[PraveenMenon]

U r using DAO.. right?

sql = "SELECT * FROM tblInput WHERE (((month([InputDate])) = " & f!month & " AND ((Year([InputDate])) = " & f!year & "0 And ((EmployeeID) = " & f!EmployeeID & &quot)) ORDER BY InputDate"

You may also need a single quote enclosing the f!EmployeeID etc, if their datatype is text in the db. All the Best
Praveen Menon
pcmin@rediffmail.com

 

[Fireman1143]

Thanks Praveen

I'll print this and give it a shot on Monday.

Fireman1143