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.



Blue Claw Database Design is your premier source of Microsoft Access programming and database support. Both small business and department-level databases. Desktop installation as well as cloud/internet based solutions.


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:

Software Risk Assessment
 





Blue Claw Database Design Downloadable Tutorial:
Multi Select List Box Query Parameters  





A Blue Claw Software Design Template:

Subscription Order Control Database
 



Contact Information

Copyright 2000-2017 Blue Claw Database Design