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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to I save My Recordset as Query
- Thread starter mundia22
- Start date
thornmastr
Programmer
You need to look up Querydef in Access Help....whoops. Yours is not working too well. What version of Access are you using. i will try to get you some information. Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com
Assuming your recordset is based on an SQL statement (eg set rst=db.openrecordset("SELECT * FROM tblWotsit;"
and you are using DAO then:
Dim qd As DAO.QueryDef
set qd=currentdb.CreateQueryDef("qryName",rst.name)
set qd=nothing
HTH
Ben ----------------------------------------
Ben O'Hara
----------------------------------------
and you are using DAO then:
Dim qd As DAO.QueryDef
set qd=currentdb.CreateQueryDef("qryName",rst.name)
set qd=nothing
HTH
Ben ----------------------------------------
Ben O'Hara
----------------------------------------
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question