"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 : Forms
|
|
Description:
|
Access Forms working with data in ACCDB, MDB, and ADPs, subforms, and spell checking
|
Module: modForms_Jet
Routines for Microsoft Access forms using Jet (for MDB/ACCDB, not ADP)
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modForms_Jet module
|
|
GetFormRecordNumberDAO
|
Procedure
|
Returns the current record number of a form in a Jet database
Note that the concept of a record number is not particularly useful (or even desirable) in a relational database like Access.
However, when developing your own custom navigation bars in forms, you may want to include the current record number like the standard Access form does.
This function uses a DAO property called AbsolutePosition that returns the current record number.
This number is not guaranteed to be accurate in multi-user scenarios and should be used for informational/display purposes only.
Never rely on a record number for programmatic navigation purposes.
The most common way to call this function is from a form's OnCurrent event. This allows you to keep an up-to-date value as the user moves through the form's records.
|
|
GetFormsPercentPositionDAO
|
Procedure
|
Returns the percent position of a form in a Jet database. Note that this is not available for forms in ADPs, since those recordsets do not support PercentPosition.
This is useful if you are creating your own custom navigation buttons on a form and want to display a progress meter with the percentage position.
This function uses the form's RecordsetClone method. As such, it requires that the form be bound to a data source.
Note the number returned is an integer, so the percent position value is approximate.
The most common way to call this function is from a form's OnCurrent event. This allows you to keep an up-to-date value as the user moves through the form's records.
This number is not guaranteed to be accurate in multi-user scenarios and should be used for informational/display purposes only. Never rely on a record number for programmatic navigation purposes.
|
|
IsFormOnFirstRecordDAO
|
Procedure
|
Determines if the current record of a form in a Jet database is on the first record
This can be useful if you have custom navigation buttons for 'move first', 'move next', etc.
and you want to disable the 'move first' button when the form is on the first record.
|
|
IsFormOnLastRecordDAO
|
Procedure
|
Determines if the current record of a form in a Jet database is on the last record.
This can be useful if you have custom navigation buttons for 'move first', 'move next', etc.
and you want to disable the 'move last' button when the form is on the last record.
|
|
ListFillRelations
|
Procedure
|
Provides a list fill function for a list/combo box for a list of relations in a Jet database
|
|
ListFillTables
|
Procedure
|
Provides a list fill function for a list/combo box for a list of tables in a Jet database.
|
|
ObjectNamesToArray
|
Procedure
|
Loads an array with names of all of an object type
|
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)
