How to use a query in code?

[hazelett]

I need to know how to use one of my existing queries as the record source using vba. I've tried the examples in my book but it never works. I am trying to export this data from the query into and ascii file but never get a recordset that I can use. Any information would be most appreciated and a clear example or two in code would be wonderful. I'm using access 2000.

Thanks

Terry

 

[mymou]

is this what you looking for?

Set oRS = oConn.Execute("qryQueryName&quot

Stew