Programmatically accesing query results

  • Thread starter Thread starter shithappens
  • Start date Start date
S

shithappens

This may be a basic thing to do but im stumped ....so please help

I wish to run a query and then cycle through the results and write
just one field into a text file in cvs format

To date i have used recordsets to cycle data but with the required
items needing to be found across several linked tables based on what
is selected in a combo box by the user a query seems the easiest way.
(I have this functionality already)

QUESTION How do i access the query results much like a recordset so
that i can cycle through the results ????
 
This may be a basic thing to do but im stumped ....so please help

I wish to run a query and then cycle through the results and write
just one field into a text file in cvs format

To date i have used recordsets to cycle data but with the required
items needing to be found across several linked tables based on what
is selected in a combo box by the user a query seems the easiest way.
(I have this functionality already)

QUESTION How do i access the query results much like a recordset so
that i can cycle through the results ????
Click to expand...

Simple. Open your recordset based on a querydef (query) or stored
procedure (if you're using ADO). Check out QueryDef.OpenRecordset in
the help.

something like
dim qdf as dao.querydef
set qdf=dbengine(0)(0).openquerydef("Queryname")
set rs = qdf.openrecordset
then you can loop through the recordset as you are accustomed to doing.
 
Simple. Open your recordset based on a querydef (query) or stored
procedure (if you're using ADO). Check out QueryDef.OpenRecordset in
the help.

something like
dim qdf as dao.querydef
set qdf=dbengine(0)(0).openquerydef("Queryname")
set rs = qdf.openrecordset
then you can loop through the recordset as you are accustomed to doing.
Click to expand...

Cheers man your my Dady!!!!!!

just joking but hell thanks for that
 
Back
Top