Recordset from recordset

[Kim Baker]

Problem creating a recordset object from another recordset object.
1. create first object. rstTemp with 10 fields - no problem
2. create second object rstTemp2 with one field - no problem
3. Attempt to create a third object with the following suedo code
fails.

SELECT rstTemp!fieldname1
FROM rstTemp
WHERE rstTemp!fieldname2 = rstTemp2!fieldname1
More manipulation after creating this object.....
In execution I get an error stating rstTemp ( in the FROM line ) is
not recognised as a table or query. And of course it is not.

I realise that there may be better ways of doing this but I would like
to know if I can use a recordset object this way.
Cheers
Remove undies to reply

[MacDermott]

AFAIK you cannot.

"Kim Baker" <ki*******@undiesyahoo.com.au> wrote in message
news:0q********************************@4ax.com...

Problem creating a recordset object from another recordset object.
1. create first object. rstTemp with 10 fields - no problem
2. create second object rstTemp2 with one field - no problem
3. Attempt to create a third object with the following suedo code
fails.

SELECT rstTemp!fieldname1
FROM rstTemp
WHERE rstTemp!fieldname2 = rstTemp2!fieldname1
More manipulation after creating this object.....
In execution I get an error stating rstTemp ( in the FROM line ) is
not recognised as a table or query. And of course it is not.

I realise that there may be better ways of doing this but I would like
to know if I can use a recordset object this way.
Cheers
Remove undies to reply

[Pieter Linden]

Kim Baker <ki*******@undiesyahoo.com.au> wrote in message news:<0q********************************@4ax.com>. ..

Problem creating a recordset object from another recordset object.
1. create first object. rstTemp with 10 fields - no problem
2. create second object rstTemp2 with one field - no problem
3. Attempt to create a third object with the following suedo code
fails.

SELECT rstTemp!fieldname1
FROM rstTemp
WHERE rstTemp!fieldname2 = rstTemp2!fieldname1
More manipulation after creating this object.....
In execution I get an error stating rstTemp ( in the FROM line ) is
not recognised as a table or query. And of course it is not.

I realise that there may be better ways of doing this but I would like
to know if I can use a recordset object this way.
Cheers
Remove undies to reply

You can filter the number of records, though...
http://www.mvps.org/access/modules/mdl0010.htm

Hey, Steve J, can you do this kind of thing with an ADO fabricated
recordset or somesuch?

[Kim Baker]

Many thanks for your replies. I've used recordset filtering to get
around the problem but it would have been interesting if I could have
used the recordset object directly.
On Thu, 23 Sep 2004 19:21:06 +1000, Kim Baker
<ki*******@undiesyahoo.com.au> wrote:

Problem creating a recordset object from another recordset object.
1. create first object. rstTemp with 10 fields - no problem
2. create second object rstTemp2 with one field - no problem
3. Attempt to create a third object with the following suedo code
fails.

SELECT rstTemp!fieldname1
FROM rstTemp
WHERE rstTemp!fieldname2 = rstTemp2!fieldname1
More manipulation after creating this object.....
In execution I get an error stating rstTemp ( in the FROM line ) is
not recognised as a table or query. And of course it is not.

I realise that there may be better ways of doing this but I would like
to know if I can use a recordset object this way.
Cheers
Remove undies to reply

Remove undies to reply