Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DAO openrecordset with query question

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
Hi,

When opening the recordset, opening a table, no problem.
When opening the recordset, opening a query I get 'Too few parameter, expected 1'

Any ideas?

Heres the code



Dim dbs As Database
Dim rst_etracker As Recordset
Dim etracker_criteria As String

Set dbs = CurrentDb


Set rst_etracker = dbs.OpenRecordset("SELECT * from qry_etracker_check_hours")
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top