"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:
|
Microsoft Access : Environment
|
|
Description:
|
Access application, ADP, and startup routines, managing the Access window, printers, ribbons, status bar, and Microsoft Visual SourceSafe
|
Module: modADP
Routines for running an Access Data Projects (ADPs)
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modADP module
|
|
ClearFormServerFilter
|
Procedure
|
Clears any server filters that may have been saved with the Form.
|
|
ClearReportServerFilter
|
Procedure
|
Clears any server filters that may have been saved with the report.
|
|
GetSysCommentsText
|
Procedure
|
Get TSQL or other text from syscomments for the specified object
|
|
GetSysObjectID
|
Procedure
|
Returns the id of the specified object from the SQL Server/MSDE sysobjects table.
|
|
IsADPSystemObject
|
Procedure
|
Determines if the specified object is a system object (for ADPs only)
|
|
IsCurrentProjectADE
|
Procedure
|
Determines if the current project is an ADE.
|
|
IsSystemTable_ADP
|
Procedure
|
Determines if the specified table is a system object.
|
|
ObjectNameHasOwner
|
Procedure
|
Determines if the specified object name has an owner name prepended.
|
|
ParseADPObjectName
|
Procedure
|
Breaks the specified object name into owner and object components.
|
|
PopulateSysUsersArray
|
Procedure
|
Populates a dynamic array with a list of users from SQL Server sysusers table.
|
|
StripADPOwnerName
|
Procedure
|
Strips the owner name from the beginning of an SQL Server object name.
|
|
TableViewNamesToArray
|
Procedure
|
Loads an array with the tables or views in an ADP with otions to include owner and exclude system objects
|
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)
