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

How to get more records from table and getting them with DAO?

P: 15
Hello,
How can I get more records with DAO.
I write
Dim rs As DAO.Recordset
'selecting data through SQL then
with "rs("Fieldname")"
I can get the data if only 1 row is back from SQL query. How can I write if I get more than 1 row from table. is it like this
with rs(0,"Fieldname")
please reeply as soon as possible, Thnaks in advance
Sep 5 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 126
Hello,
How can I get more records with DAO.
I write
Dim rs As DAO.Recordset
'selecting data through SQL then
with "rs("Fieldname")"
I can get the data if only 1 row is back from SQL query. How can I write if I get more than 1 row from table. is it like this
with rs(0,"Fieldname")
please reeply as soon as possible, Thnaks in advance
Try using rs!fieldname for each field in a row.
Then, when it comes to move to the next row, just use:
rs.MoveNext
Hope this helps.
Sep 5 '07 #2

P: 15
Try using rs!fieldname for each field in a row.
Then, when it comes to move to the next row, just use:
rs.MoveNext
Hope this helps.

I will try this, but if u have any other idea plz write that also. Thanks a lot.
Sep 5 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.