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

Understanding Recordsets

P: n/a
I am reading a book (Beginning Access 2002 VBA) and I am having a problem
understanding the use of recordsets.

Can anyone explain the value of creating recordsets or how they are
practically used?

Also, any suggestions on other VBA training. This is a decent book but I
believe that I almost need a workbook with example problems and answers to
get more hands on training.
Jan 21 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
JEHalm wrote:
I am reading a book (Beginning Access 2002 VBA) and I am having a problem
understanding the use of recordsets.

Can anyone explain the value of creating recordsets or how they are
practically used?

Also, any suggestions on other VBA training. This is a decent book but I
believe that I almost need a workbook with example problems and answers to
get more hands on training.


A recordset is the backbone of your forms and reports. The data
displayed in a form or report comes from a recordset.

If you are a beginner, I would recommend a StepByStep book on Access.
http://www.amazon.com/gp/product/073...lance&n=283155

If you aren't willing to do the exercises this book is not worth buying.
Its not a book you simply read...to get any benefit you need to get
your hands dirty and do the examples. You get a decent foundation on
programming VBA. After that, hang out in this newsgroup and read the
threads.
Jan 21 '06 #2

P: n/a
Thanks, do you know any good ones for Excel VBA also. I'm very proficient in
Excel (more so than Access) but would like to incorporate VBA for Excel in my
skill set also.

salad wrote:
I am reading a book (Beginning Access 2002 VBA) and I am having a problem
understanding the use of recordsets.

[quoted text clipped - 5 lines]
believe that I almost need a workbook with example problems and answers to
get more hands on training.


A recordset is the backbone of your forms and reports. The data
displayed in a form or report comes from a recordset.

If you are a beginner, I would recommend a StepByStep book on Access.
http://www.amazon.com/gp/product/073...lance&n=283155

If you aren't willing to do the exercises this book is not worth buying.
Its not a book you simply read...to get any benefit you need to get
your hands dirty and do the examples. You get a decent foundation on
programming VBA. After that, hang out in this newsgroup and read the
threads.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200601/1
Jan 23 '06 #3

P: n/a
John via AccessMonster.com wrote:
Thanks, do you know any good ones for Excel VBA also. I'm very proficient in
Excel (more so than Access) but would like to incorporate VBA for Excel in my
skill set also.
Regarding a book, no. Look for the words Excel and VBA at Amazon or
barnes and noble. However, you might want to look at various sites at
http://www.mvps.org. Ex: one link at the site is http://orlando.mvps.org/

salad wrote:
I am reading a book (Beginning Access 2002 VBA) and I am having a problem
understanding the use of recordsets.


[quoted text clipped - 5 lines]
believe that I almost need a workbook with example problems and answers to
get more hands on training.


A recordset is the backbone of your forms and reports. The data
displayed in a form or report comes from a recordset.

If you are a beginner, I would recommend a StepByStep book on Access.
http://www.amazon.com/gp/product/073...lance&n=283155

If you aren't willing to do the exercises this book is not worth buying.
Its not a book you simply read...to get any benefit you need to get
your hands dirty and do the examples. You get a decent foundation on
programming VBA. After that, hang out in this newsgroup and read the
threads.


Jan 23 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.