Home  Fees/Services  Access Examples  Tutorials  Access Download  Articles  Search  Contact  Privacy  Links
Application Object Examples
VBA Application Object Examples

Visual Basic Application Objects

 





Access Error
AddToFavorites
BuildCriteria
CloseCurrentDatabase
CodeDB
CompactRepair
ConvertAccessProject

 

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.



Our programming team has 15 members containing a wide variety of technical database knowledge and programming experience. Experts in small business management and scientific database programming.

Did you know you don't need to move to SQL/Server to run and manage your Access database on the net. There are many alternative solutions. Among them are Amazon's AWS cloud services and various hosting services in nearly every state.


AddToFavorites
The AddToFavorites method adds the name of the current database to the Favorites folder.

BuildCriteria
The BuildCriteria method returns a criteria string as it would appear in the criteria line in the query design grid.

CloseCurrentDatabase Method
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 through Automation.

CodeDb
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.

Compact/Repair
Compacts and repairs the specified database (.mdb) or Access project (.adp) file. Returns a Boolean; True if the process was successful.

ConvertAccessProjectod
Converts the specified Access database file from one version to another Access version.








A Blue Claw Database Design Article:

ODBC Links To Other DB Systems
 





Blue Claw Database Design Downloadable Tutorial:
Use Global Variables as Parameters  





A Blue Claw Software Design Template:

Farmer's Feed Inventory Tracking Database
 



Contact Information

Copyright 2000-2017 Blue Claw Database Design