Pacific Database

Home | Contact | FAQs | View Cart

A world of information at your fingertips

MVP Centre

Welcome to the MVP Centre. This page is the portal to a wealth of information about Microsoft Access.

Recordsets

You are free to copy and use any of the samples supplied on this website for use in your own projects, provided that all copyright notices remain intact as part of the code. You may not publish the code to any website or other medium without the express written permission of the copyright holder. Each sample is provided on an "as is" basis. No warranty is expressed or implied, and no support is offered.

ADO

Creating & using a persistent ADO Recordset How to persist (save) an ADO recordset to XML or ADTG format, and how to work with data persisted in such files.
Creating an ADO Recordset from a Command object How to create an ADO recordset using an ADO Command object.
Creating a shaped ADO Recordset How to create & use shaped ADO recordsets.
Creating schema Recordsets in ADO How to create & use ADO schema recordsets.
Disconnected ADO Recordsets How to create & use disconnected ADO recordsets.
Editing ADO Recordset data How to edit ADO recordset data.
Opening an ADO Recordset containing multiple SELECT queries How to use an ADO recordset containing multiple SELECT queries.
Find Using the Find method to find data in ADO recordsets.
Seek Using the Seek method to find data in ADO recordsets.
   

DAO

FindFirst Using the FindFirst methods to find data in DAO recordsets.
Seek Using the Seek method to find data in DAO recordsets.
Cancelling a DAO Recordset edit operation How to cleanly cancel adding/editing data in a DAO recordset.
Creating and using DAO Recordset clones Using DAO Recordset clones.
Opening a DAO Recordset containing multiple SELECT queries How to use a DAO recordset containing multiple SELECT queries.
Using arrays with DAO Recordsets How to use arrays with a DAO recordset.
Using DAO Bookmarks How to use DAO Bookmarks.
   

ADO & DAO

RecordCount Using the RecordCount property with ADO & DAO recordsets.
Testing for an empty Recordset How to test for empty ADO & DAO recordsets.
AbsolutePosition & AbsolutePercent Using the AbsolutePosition & AbsolutePercent properties of ADO & DAO recordsets.
Deleting rows How to delete data rows in ADO & DAO recordsets.
Using MoveNext and MovePrevious Navigating ADO & DAO recordsets using MovePrevious & MoveNext.
Adding a row to an ADO & DAO Recordset How to add rows to an ADO & DAO a recordset.