Access Application Objects
Access application objects contain all of the Access database objects and collections. These methods can be used to apply property settings to the entire Microsoft Access program. For example, you can use the SetOption
Method of the application object to set database options from Visual Basic.
As time permits we will add definitions to each of the
Application object methods listed below:
Access Error Method
You can use the Access Error method
to return the description associated with a Microsoft Access or DAO error when
the error hasn't actually occurred. However, you can't use the AccessError
method for ADO errors.
We have dozens of downloadable Access small business databases for you to learn and examine.
With our new partnership with Jay McCormick we have extensive programming support in SQL/Server database, MS Access software, Power BI applications, .Net web development, PHP, Excel & Outlook customization.
The AddToFavorites method adds the name of the
current database to the Favorites folder.
The BuildCriteria method returns a criteria string as it would appear in the
criteria line in the query design grid.
You can use the CloseCurrentDatabase
method to close the current database (either a database (.mdb)
or an Access project (.adp) from another application that has opened a database
You can use the CodeDb method in a code module to determine the name of the
Database object that refers to the database in which code is currently running.
Compacts and repairs the specified
database (.mdb) or Access project (.adp) file. Returns a Boolean; True
if the process was successful.
Converts the specified Access database file from one version to another Access version.