"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: modQueriesDAO
Create, execute, and browse Microsoft Access queries using DAO/Jet
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modQueriesDAO module
|
|
CreateNewQuery
|
Procedure
|
Saves a SQL string as a new query in the database
|
|
ExecuteQueryDAO
|
Procedure
|
Run a saved action query
|
|
ExecuteQueryParameterDAO
|
Procedure
|
Run a query that requires a parameter (the query must be an action query)
|
|
ExecuteQueryParametersDAO
|
Procedure
|
Run a query that requires multiple parameters (the query must be an action query)
|
|
ExecuteSQLDAO
|
Procedure
|
Runs a SQL string on any database (the SQL string must be an non-row-returning action query)
|
|
OpenRecordsetParameterDAO
|
Procedure
|
Open a DAO recordset on a query that requires a parameter and retrieves records (can't be an action query)
|
|
OpenRecordsetParametersDAO
|
Procedure
|
Open a DAO recordset on a query that requires a parameter and retrieves records (can't be an action query)
|
|
OpenRecordsetQueryDAO
|
Procedure
|
Open a DAO recordset on a query 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)
