Friday 22 June 2012

Working with Recordsets in VBA


This article highlights ten common traps with DAO recordsets in VBA code.

Contents:
1. DAO verses ADO
2. Recordset types
3. Move with no records
4. RecordCount without MoveLast
5. MoveNext without testing EOF
6. Loop without MoveNext
7. Find without NoMatch
8. AddNew without LastModified
9. Failing to close recordsets
10. Nested recordsets



No comments:

Post a Comment