Friday, 22 June 2012

Working with Recordsets in VBA

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

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