"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: modStartup
Startup routines for an Access application
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modStartup module
|
|
GetCommandLine
|
Procedure
|
Access can be started with a command line option passed after the /cmd tag (commonly in a shortcut)
Your program can use this as a flag for special processing.
|
|
GetCommandLineValues
|
Procedure
|
Access can be started with a command line option passed after the /cmd tag (commonly in a shortcut)
Your program can use this as a flag for special processing.
If you pass multiple values in this manner separated by a delimiter, the values are loaded into the passed array.
|
|
OpenAllDatabases
|
Procedure
|
Use this procedure when there are multiple backend databases to keep open; or close the previously opened databases
NOTE: Significant performance improvements can be achieved by keeping a handle open during the entire time your application is running.
Visit http://www.fmsinc.com/MicrosoftAccess/performance/linkeddatabase.html for more information.
|
|
OpenBackendDatabase
|
Procedure
|
Open a handle to a backend database and keep it open; or close the previously opened database.
NOTE: Significant performance improvements can be achieved by keeping a database handle open during the entire time your application is running.
Visit http://www.fmsinc.com/MicrosoftAccess/performance/linkeddatabase.html for more information.
|
|
RelinkAllTables
|
Procedure
|
Relink all the linked (attached) tables in the current database to a new database
|
|
RelinkTable
|
Procedure
|
Relink (attach) one table in the current database to a new database
|
|
RelinkTableDef
|
Procedure
|
Relink (attach) a table definition to a new database (eliminates the need to create a new database handle if processing lots of tables)
|
|
SetErrorTrapping
|
Procedure
|
Set or reset error trapping setting so errors are properly handled while your application runs.
This setting can be manually set from the IDE under the Tools, Options menu, General Tab.
If error trapping is set to Break on All Errors, code with On Error Resume Next will stop if an error occurs.
This setting is at the machine level, not your application so what works fine on one machine may fail on another due to this setting.
To avoid this, make sure error trapping is set to Break in Class Modules by calling this routine when your application starts.
When the application finishes, call this routine again to reset the setting back to the original 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)
