"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
|
|
Module: modMSysObjectsInfo
Retrieve Access object information from the MSysObjects table
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modMSysObjectsInfo module
|
|
AccessObjectsToArray
|
Procedure
|
Builds a zero based array containing a dictionary (list) of all Access objects using the MSysObjects table.
The array includes the object type and the object name.
|
|
AccessObjectsToTable
|
Procedure
|
Builds a dictionary of Access objects to a table.
If the table exists, it is emptied. If the table does not already exist, it is created. The created table has the following structure:
FIELD NAME FIELD TYPE
ObjectType Text(10)
ObjectName Text(64)
|
|
GetAccessID
|
Procedure
|
Returns the internal Access ID number for an object.
Access maintains a unique long integer id number for every object in the database. This function returns that value.
|
|
GetAccessIDInfo
|
Procedure
|
Get the name of the object associated by the internal Access ID number.
Access maintains a unique long integer id number for every object in the database. This function returns the object with the specified value.
|
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)
