Using OpenRecordset

F

franky

Hello.

How do I open a recorset object by passing in the name of the query. For
example:

Public Sub Testing(QueryName As String)

Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset(QueryName)
....

This will produce the following error; "Object variable or With block
variable not set". I've also tried;CurrentDb.OpenRecordset("""" & QueryName
& """"). I need to be able to pass the query name and NOTthe sql statement.
Any suggestions?

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 and SQL Server 2005 and DAO recordset 1
CurrentDb.OpenRecordset error (error 91 - Object variable or With block variable not set) 3
Using excel to access MS Access saved query 1
VBA works in orignal but fails in copy of database 1
DAO Recordset Issue 1
OpenRecordset Error 3
Help with loop 2
How to write a parameter query in recordset 3

Top