"The code is exactly
how I would like to write code and the algorithms used are very
efficient and well-documented."
Van T. Dinh, Microsoft MVP
|
|
|
Category:
|
Database : Access/Jet
|
|
Description:
|
Microsoft Access Jet databases and their objects (MDB and ACCDB database formats)
|
Module: modTableCopyDataDAO
Copy records (including complex fields) between tables using DAO
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modTableCopyDataDAO module
|
|
CopyComplexFieldDAO
|
Procedure
|
Copy the values in a complex field from one field to another
|
|
CopyLargeFieldDAO
|
Procedure
|
Copy contents of one large field to another due to max 32K chunk
|
|
CopyRecordComplexDAO
|
Procedure
|
Copy a record from one recordset to another based on field names including complex field types
The destination table/recordset must have all the fields of the source, but the order may be different and it may have additional fields.
|
|
CopyRecordSimpleDAO
|
Procedure
|
Copy a record from one recordset to another based on field names and no complex (multivalue or attachment fields) or large fields (>32K).
The destination table/recordset must have all the fields of the source, but the order may be different and it may have additional fields.
|
|
CopyTableDataDAO
|
Procedure
|
Copy all the records from one table to another using DAO. Suppports ACCDB complex field types.
The destination table must have all the fields of the source, but the order may be different and it may have additional fields.
|
|
CopyTableDataSimpleDAO
|
Procedure
|
Copies the records from a table from one database to another using a query.
This does not support complex fields such as multivalue and attachment fields
|
Overview of Total Visual SourceBook
The source code in Total Visual
SourceBook includes modules and classes for Microsoft Access, Visual
Basic 6 (VB6), and Visual Basic for Applications (VBA) developers. Easily
add this professionally written, tested, and documented royalty-free code
into your applications to simplify your application development efforts.
Additional Resources
|
|
All Our Microsoft Access Products
(885K)
