By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,935 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Recordset from recordset

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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?
Nov 13 '05 #3

P: n/a
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
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.