"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: modQueriesADO
Create, execute, and browse Microsoft Access queries in the current project using ADO for MDB, ACCDB and ADP formats
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modQueriesADO module
|
|
ExecuteQueryParameterADO
|
Procedure
|
Run a query that requires a parameter (the query must be an action query)
|
|
ExecuteQueryParametersADO
|
Procedure
|
Run a query that requires multiple parameters (the query must be an action query)
|
|
ExecuteQuerySQLADO
|
Procedure
|
Run a saved action query or SQL string in the current database
|
|
OpenRecordsetParameterADO
|
Procedure
|
Open an ADO recordset on a query that requires a parameter and retrieves records (can't be an action query)
|
|
OpenRecordsetParametersADO
|
Procedure
|
Open an ADO recordset on a query that requires a parameter and retrieves records (can't be an action query)
|
|
OpenRecordsetQueryADO
|
Procedure
|
Open a ADO recordset on a query that retrieves records (can't be an action query)
|
|
OpenRecordsetSQLADO
|
Procedure
|
Open a ADO recordset to a SQL string that retrieves records (can't be an action query)
|
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)
