boborsipho
Programmer
I've been struggling for a while now.
How do I run a Select query in a module in MS Access?
I tried everything:
Dim sql As String
Dim rs As Recordset
Dim db As Database
Set f = Forms!frmCalender
sql = <<SQL Statement>>
Set db = CurrentDb()
Set rs = db.OpenRecordset(sql, dbOpenSnapshot)
This code gives me: "Too few parameters. Expected 1" - Error
What am I doing wrong?
Thank you
Bob
How do I run a Select query in a module in MS Access?
I tried everything:
Dim sql As String
Dim rs As Recordset
Dim db As Database
Set f = Forms!frmCalender
sql = <<SQL Statement>>
Set db = CurrentDb()
Set rs = db.OpenRecordset(sql, dbOpenSnapshot)
This code gives me: "Too few parameters. Expected 1" - Error
What am I doing wrong?
Thank you
Bob
