I'm sure this is simple, but I'm having a heck of a time trying to open an ADO recordset based off of a stored query.
I am using access 2002
Code looks something like this.
dim conn as adodb.connection
dim rs as adodb.recordset
set conn = currentproject.connection
set rs = new adodb.recordset
'normally I would do something like this
'rs.open "SELECT * FROM tblTest", conn
'however I want to use a query saved in my database
rs.open qryMyQuery, conn
'this doesn't seem to work as I'm sure the open method is looking for a string.
Any help is greatly appreciated.
Thanks,
Scott
I am using access 2002
Code looks something like this.
dim conn as adodb.connection
dim rs as adodb.recordset
set conn = currentproject.connection
set rs = new adodb.recordset
'normally I would do something like this
'rs.open "SELECT * FROM tblTest", conn
'however I want to use a query saved in my database
rs.open qryMyQuery, conn
'this doesn't seem to work as I'm sure the open method is looking for a string.
Any help is greatly appreciated.
Thanks,
Scott