creating new querydefs

S

Sasha

I"m trying to create some querydefs in VBA...
i have the references set to include the dao library

Dim R1 as dao.recordset
Dim Qry as dao.querydef
qry.name = blah
qry.SQL = "sql string"
currentdb.querydefs.append(qry)

set r1 = qry.openrecordset

I have gotten an assortment of errors, from "not
supported" to "object not set"


pls help!

thanks,
Sasha
 

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

Compile Error: Type Mismatch 3
Copy Query from MDB to ADP 1
SQL string error message 1
Creating a querydef of a stored proc on Sql Server 8
Delete a Query, or Empty it and Reload With New SQL? 3
Saving queries to backend database 3
record set for pass through query 1
Creates table instead of exporting to Excel issue 4

Top