"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: modObjects
Manage open Access objects, inventory, active objects, and minimizing, restoring and closing them
Supports the current Jet database or Access Data Project (ADP)
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modObjects module
|
|
CloseAllOpenForms
|
Procedure
|
Closes all the currently opened forms
|
|
CloseAllOpenFormsExceptOne
|
Procedure
|
Closes all the currently opened forms except for a specified form
|
|
CloseAllOpenObjects
|
Procedure
|
Closes all objects open through the user interface.
|
|
CloseAllOpenReports
|
Procedure
|
Closes all the currently opened reports
|
|
CloseAllOpenReportsExceptOne
|
Procedure
|
Closes all the currently opened forms except for a specified report
|
|
CloseObjectsOfType
|
Procedure
|
Closes all Access objects of the supplied type
|
|
GetActiveDatasheet
|
Procedure
|
Returns the name of the currently active datasheet
|
|
GetCurrentObject
|
Procedure
|
Returns the name of the current object.
Note that if you select objects in the Database Window, this procedure returns the object you selected in that window (i.e. the object does not actually need to be open.)
|
|
IsObjectHidden
|
Procedure
|
Determines if the specified Access object type and name is hidden
|
|
IsObjectOpen
|
Procedure
|
Determines if the named Access object is open
|
|
MaximizeObject
|
Procedure
|
Maximizes the specified object.
|
|
MinimizeObject
|
Procedure
|
Minimizes the specified object
|
|
ObjectExists
|
Procedure
|
Determines if this object name exists in the current project
|
|
ObjectNamesToArray
|
Procedure
|
Loads an array with names of all of an object type
|
|
OpenObjectsToArray
|
Procedure
|
Loads an array with names of all open objects of an object type
|
|
RestoreObject
|
Procedure
|
Restores the specified object (the Windows Restore command)
|
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)
