Skip to Main Content
Access 2002 Programming by Example
book

Access 2002 Programming by Example

by Bob Villareal
January 2002
Beginner content levelBeginner
576 pages
13h 23m
English
Que
Content preview from Access 2002 Programming by Example

Manipulating Recordsets Using Collections Versus Manipulating Recordsets Using Queries

The normal methods for retrieving and manipulating recordsets using Access VBA are queries and recordset loops. Yet, while there is plenty of documentation for both methods, a beginning developer may be hard-pressed to find instructions that detail when or why to use one method as opposed to another. Although some sources might explain that recordset loops should be used to modify recordset properties while queries should be used to modify recordset data, this raises more questions than it answers. For example, you can modify recordset properties using DDL (data definition language) queries and you can modify data using loops.

In a nutshell, there is an overlap ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access 2003 Programming by Example with VBA, XML, and ASP

Access 2003 Programming by Example with VBA, XML, and ASP

Julitta Korol
Microsoft® Access® 2010 Programmer's Reference

Microsoft® Access® 2010 Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison

Publisher Resources

ISBN: 0789725940Purchase book