Application Object Members

Access Developer Reference

The Application object refers to the active Microsoft Access application.

Methods

Name Description
Bb243265.methods(en-us,office.12).gif AccessError You can use the AccessError method to return the descriptive string associated with a Microsoft Access or DAO error.
Bb243265.methods(en-us,office.12).gif AddToFavorites The AddToFavorites method adds a hyperlink address to the Favorites folder.
Bb243265.methods(en-us,office.12).gif BuildCriteria The BuildCriteria method returns a parsed criteria string as it would appear in the query design grid, in Filter By Form or Server Filter By Form mode. For example, you may want to set a form's Filter or ServerFilter property based on varying criteria from the user. You can use the BuildCriteria method to construct the string expression argument for the Filter or ServerFilter property. String.
Bb243265.methods(en-us,office.12).gif CloseCurrentDatabase You can use the CloseCurrentDatabase method to close the current database (either a Microsoft Access database or an Access project (.adp) from another application that has opened a database through Automation.
Bb243265.methods(en-us,office.12).gif 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. Use the CodeDb method to access Data Access Objects (DAO) that are part of a library database.
Bb243265.methods(en-us,office.12).gif ColumnHistory Gets the history of values that have been stored in a Memo field.
Bb243265.methods(en-us,office.12).gif CompactRepair Compacts and repairs the specified database or Microsoft Access project (.adp) file. Returns a Boolean; True if the process was successful.
Bb243265.methods(en-us,office.12).gif ConvertAccessProject Converts the specified Microsoft Access file from one version to another.
Bb243265.methods(en-us,office.12).gif CreateAccessProject You can use the CreateAccessProject method to create a new Microsoft Access project (.adp) on disk.
Bb243265.methods(en-us,office.12).gif CreateAdditionalData Creates an AdditionalData object that can be used to add additional tables and queries to the parent table that is being exported by the ExportXML method.
Bb243265.methods(en-us,office.12).gif CreateControl The CreateControl method creates a control on a specified open form. For example, suppose you are building a custom wizard that allows users to easily construct a particular form. You can use the CreateControl method in your wizard to add the appropriate controls to the form.
Bb243265.methods(en-us,office.12).gif CreateForm The CreateForm method creates a form and returns a Form object.
Bb243265.methods(en-us,office.12).gif CreateGroupLevel You can use the CreateGroupLevel method to specify a field or expression on which to group or sort data in a report.
Bb243265.methods(en-us,office.12).gif CreateNewWorkgroupFile Creates a new workgroup file so that a user can securely access a database.
Bb243265.methods(en-us,office.12).gif CreateReport The CreateReport method creates a report and returns a Report object. For example, suppose you are building a custom wizard to create a sales report. You can use the CreateReport method in your wizard to create a new report based on a specified report template.
Bb243265.methods(en-us,office.12).gif CreateReportControl The CreateReportControl method creates a control on a specified open report. For more information, see the CreateControl method.
Bb243265.methods(en-us,office.12).gif CurrentDb The CurrentDb method returns an object variable of type Database that represents the database currently open in the Microsoft Access window.
Bb243265.methods(en-us,office.12).gif CurrentUser You can use the CurrentUser method to return the name of the current user of the database.
Bb243265.methods(en-us,office.12).gif DAvg You can use the DAvg function to calculate the average of a set of values in a specified set of records (a domain).
Bb243265.methods(en-us,office.12).gif DCount You can use the DCount function to determine the number of records that are in a specified set of records (a domain).
Bb243265.methods(en-us,office.12).gif DDEExecute You can use the DDEExecute statement to send a command from a client application to a server application over an open dynamic data exchange (DDE) channel.
Bb243265.methods(en-us,office.12).gif DDEInitiate You can use the DDEInitiate function to begin a dynamic data exchange (DDE) conversation with another application. The DDEInitiate function opens a DDE channel for transfer of data between a DDE server and client application.
Bb243265.methods(en-us,office.12).gif DDEPoke You can use the DDEPoke statement to supply text data from a client application to a server application over an open dynamic data exchange (DDE) channel.
Bb243265.methods(en-us,office.12).gif DDERequest You can use the DDERequest function over an open dynamic data exchange (DDE) channel to request an item of information from a DDE server application.
Bb243265.methods(en-us,office.12).gif DDETerminate You can use the DDETerminate statement to close a specified dynamic data exchange (DDE) channel.
Bb243265.methods(en-us,office.12).gif DDETerminateAll You can use the DDETerminateAll statement to close all open dynamic data exchange (DDE) channels.
Bb243265.methods(en-us,office.12).gif DefaultWorkspaceClone You can use the DefaultWorkspaceClone method to create a new Workspace object without requiring the user to log on again. For example, if you need to conduct two sets of transactions simultaneously in separate workspaces, you can use the DefaultWorkspaceClone method to create a second Workspace object with the same user name and password without prompting the user for this information again.
Bb243265.methods(en-us,office.12).gif DeleteControl The DeleteControl method deletes a specified control from a form.
Bb243265.methods(en-us,office.12).gif DeleteReportControl The DeleteReportControl method deletes a specified control from a report.
Bb243265.methods(en-us,office.12).gif DFirst You can use the DFirst function to return a random record from a particular field in a table or query when you simply need any value from that field.
Bb243265.methods(en-us,office.12).gif DLast You can use the DLast function to return a random record from a particular field in a table or query when you simply need any value from that field.
Bb243265.methods(en-us,office.12).gif DLookup You can use the DLookup function to get the value of a particular field from a specified set of records (a domain).
Bb243265.methods(en-us,office.12).gif DMax You can use DMax function to determine maximum value in a specified set of records (a domain).
Bb243265.methods(en-us,office.12).gif DMin You can use DMin function to determine minnimum value in a specified set of records (a domain).
Bb243265.methods(en-us,office.12).gif DStDev Estimates the standard deviation across a population sample in a specified set of records (a domain).
Bb243265.methods(en-us,office.12).gif DStDevP Estimates the standard deviation across a population in a specified set of records (a domain).
Bb243265.methods(en-us,office.12).gif DSum Estimates the variance across a sample in a specified set of records (a domain).
Bb243265.methods(en-us,office.12).gif DVar Estimates the variance across a sample in a specified set of records (a domain).
Bb243265.methods(en-us,office.12).gif DVarP Calculates the variance of a population in a specified set of records (a domain).
Bb243265.methods(en-us,office.12).gif Echo The Echo method specifies whether Microsoft Access repaints the display screen.
Bb243265.methods(en-us,office.12).gif EuroConvert You can use the EuroConvert function to convert a number to euro or from euro to a participating currency. You can also use it to convert a number from one participating currency to another by using the euro as an intermediary (triangulation). The EuroConvert function uses fixed conversion rates established by the European Union.
Bb243265.methods(en-us,office.12).gif Eval You can use the Eval function to evaluate an expression that results in a text string or a numeric value.
Bb243265.methods(en-us,office.12).gif ExportNavigationPane Saves the current configuration of the Navigation Pane to an XML file.
Bb243265.methods(en-us,office.12).gif ExportXML The ExportXML method allows developers to export XML data, schemas, and presentation information from Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), Microsoft SQL Server 6.5 or later, or the Microsoft Access database engine.
Bb243265.methods(en-us,office.12).gif FollowHyperlink The FollowHyperlink method opens the document or Web page specified by a hyperlink address.
Bb243265.methods(en-us,office.12).gif GetHiddenAttribute The GetHiddenAttribute method returns the value of hidden attribute of a Microsoft Access object in the object's Properties dialog box, available by selecting the object in the Database window and clicking Properties on the View menu.
Bb243265.methods(en-us,office.12).gif GetOption The GetOption method returns the current value of an option in the Access Options dialog box, available by clicking the Microsoft Office Button and then clicking Access Options. Variant.
Bb243265.methods(en-us,office.12).gif GUIDFromString The GUIDFromString function converts a string to a GUID, which is an array of type Byte.
Bb243265.methods(en-us,office.12).gif HtmlEncode Converts a string to an HTML-encoded string.
Bb243265.methods(en-us,office.12).gif hWndAccessApp You can use the hWndAccessApp method to determine the handle assigned by Microsoft Windows to the main Microsoft Access window.
Bb243265.methods(en-us,office.12).gif HyperlinkPart The HyperlinkPart method returns information about data stored as a Hyperlink data type.
Bb243265.methods(en-us,office.12).gif ImportNavigationPane Loads a saved Navigation Pane configuration from disk.
Bb243265.methods(en-us,office.12).gif ImportXML The ImportXML method allows developers to import XML data and/or schema information into Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), Microsoft SQL Server 7.0 or later, or the Microsoft Access database engine.
Bb243265.methods(en-us,office.12).gif LoadCustomUI Loads XML markup that represents a customized Ribbon.
Bb243265.methods(en-us,office.12).gif LoadPicture The LoadPicture method loads a graphic into an ActiveX control.
Bb243265.methods(en-us,office.12).gif NewAccessProject You can use the NewAccessProject method to create and open a new Microsoft Access project (.adp) as the current Access project in the Microsoft Access window.
Bb243265.methods(en-us,office.12).gif NewCurrentDatabase Creates a new Microsoft Access database.
Bb243265.methods(en-us,office.12).gif Nz You can use the Nz function to return zero, a zero-length string (" "), or another specified value when a Variant is Null. For example, you can use this function to convert a Null value to another value and prevent it from propagating through an expression.
Bb243265.methods(en-us,office.12).gif OpenAccessProject You can use the OpenAccessProject method to open an existing Microsoft Access project (.adp) as the current Access project in the Microsoft Access window.
Bb243265.methods(en-us,office.12).gif OpenCurrentDatabase You can use the OpenCurrentDatabase method to open an existing Microsoft Access database as the current database.
Bb243265.methods(en-us,office.12).gif PlainText Strips the rich text formatting from a string and returns an unformatted text string.
Bb243265.methods(en-us,office.12).gif Quit The Quit method quits Microsoft Access. You can select one of several options for saving a database object before quitting.
Bb243265.methods(en-us,office.12).gif RefreshDatabaseWindow The RefreshDatabaseWindow method updates the Database window after a database object has been created, deleted, or renamed.
Bb243265.methods(en-us,office.12).gif RefreshTitleBar The RefreshTitleBar method refreshes the Microsoft Access title bar after the AppTitle or AppIcon property has been set in Visual Basic.
Bb243265.methods(en-us,office.12).gif Run You can use the Run method to carry out a specified Microsoft Access or user-defined Function or Sub procedure. Variant.
Bb243265.methods(en-us,office.12).gif RunCommand The RunCommand method runs a built-in command.
Bb243265.methods(en-us,office.12).gif SetDefaultWorkgroupFile Sets the default workgroup file to the specified file.
Bb243265.methods(en-us,office.12).gif SetHiddenAttribute The SetHiddenAttribute method sets the hidden attribute of an Access object.
Bb243265.methods(en-us,office.12).gif SetOption The SetOption method sets the current value of an option in the Access Options dialog box.
Bb243265.methods(en-us,office.12).gif StringFromGUID The StringFromGUID function converts a GUID, which is an array of type Byte, to a string.
Bb243265.methods(en-us,office.12).gif SysCmd You can use the SysCmd method to, display a progress meter or optional specified text in the status bar, return information about Microsoft Access and its associated files, or return the state of a specified database object (to indicate whether the object is open, is a new object, or has been changed but not saved). Variant.
Bb243265.methods(en-us,office.12).gif TransformXML Applies an Extensible Stylesheet Language (XSL) stylesheet to an XML data file and writes the resulting XML to an XML data file.

Properties

Name Description
Bb243265.properties(en-us,office.12).gif AnswerWizard Rreturns a reference to the current AnswerWizard object and its related properties. Read-only AnswerWizard object.
Bb243265.properties(en-us,office.12).gif Application You can use the Application property to access the active Microsoft Access Application object and its related properties. Read-only Application object.
Bb243265.properties(en-us,office.12).gif Assistance Returns an IAssistance object that represents the Microsoft Office Help Viewer. Read-only.
Bb243265.properties(en-us,office.12).gif Assistant ClippyIsDeadYou can use the Assistant property to return a reference to the Assistant object. Read-only Assistant object.
Bb243265.properties(en-us,office.12).gif AutoCorrect Returns an AutoCorrect object that represents the AutoCorrect settings for Microsoft Office Access 2007. Read-only.
Bb243265.properties(en-us,office.12).gif AutomationSecurity Returns or sets an MsoAutomationSecurity constant that represents the security mode that Microsoft Access uses when it is programmatically opening files. Read/write.
Bb243265.properties(en-us,office.12).gif BrokenReference Returns a Boolean indicating whether the current database has any broken references to databases or type libraries. True if there are any broken references. Read-only.
Bb243265.properties(en-us,office.12).gif Build Returns as a Long representing the build number of the currently installed copy of Microsoft Office Access 2007. Read-only.
Bb243265.properties(en-us,office.12).gif CodeContextObject You can use the CodeContextObject property to determine the object in which a macro or Visual Basic code is executing. Read-only Object.
Bb243265.properties(en-us,office.12).gif CodeData You can use the CodeData property to access the CodeData object and its related collections. Read-only CodeData object.
Bb243265.properties(en-us,office.12).gif CodeProject You can use the CodeProject property to access the CodeProject object and its related collections, properties, and methods. Read-only CodeProject object.
Bb243265.properties(en-us,office.12).gif COMAddIns You can use the COMAddIns property to return a reference to the current COMAddIns collection object and its related properties. Read-only COMAddIns object.
Bb243265.properties(en-us,office.12).gif CommandBars You can use the CommandBars property to return a reference to the CommandBars collection object. Read-only CommandBars object.
Bb243265.properties(en-us,office.12).gif CurrentData You can use the CurrentData property to access the CurrentData object and its related collections. Read-only CurrentData object.
Bb243265.properties(en-us,office.12).gif CurrentObjectName You can use the CurrentObjectName property with the Application object to determine the name of the active database object. The active database object is the object that has the focus or in which code is running. Read-only String.
Bb243265.properties(en-us,office.12).gif CurrentObjectType You can use the CurrentObjectType property together with the Application object to determine the type of the active database object (table, query, form, report, macro, module, server view, database diagram, or stored procedure). The active database object is the object that has the focus or in which code is running. Read-only AcObjectType.
Bb243265.properties(en-us,office.12).gif CurrentProject You can use the CurrentProject property to access the CurrentProject object and its related collections, properties, and methods. Read-only CurrentProject object.
Bb243265.properties(en-us,office.12).gif DBEngine You can use the DBEngine property in Visual Basic to access the current DBEngine object and its related properties. Read-only DBEngine.
Bb243265.properties(en-us,office.12).gif DoCmd You can use the DoCmd property to access the read-only DoCmd object and its related methods. Read-only DoCmd.
Bb243265.properties(en-us,office.12).gif FeatureInstall You can use the FeatureInstall property to specify or determine how Microsoft Office Access 2007 handles calls to methods and properties that require features not yet installed. Read/write MsoFeatureInstall.
Bb243265.properties(en-us,office.12).gif FileDialog Returns a FileDialog object which represents a single instance of a file dialog box. Read-only.
Bb243265.properties(en-us,office.12).gif Forms You can use the Forms property to return a read-only reference to the Forms collection and its related properties.
Bb243265.properties(en-us,office.12).gif IsCompiled The IsCompiled property returns a Boolean value indicating whether the Visual Basic project is in a compiled state. Read-only Boolean.
Bb243265.properties(en-us,office.12).gif LanguageSettings You can use the LanguageSettings property to return a read-only reference to the current LanguageSettings object and its related properties.
Bb243265.properties(en-us,office.12).gif MacroError Returns a MacroError object that contains information about the latest error to occur in a macro. Read-only.
Bb243265.properties(en-us,office.12).gif MenuBar Specifies a custom menu to display for a Microsoft Access database. Read/write String.
Bb243265.properties(en-us,office.12).gif Modules You can use the Modules property to access the Modules collection and its related properties. Read-only Modules object.
Bb243265.properties(en-us,office.12).gif Name You can use the Name property to determine the string expression that identifies the name of an object. Read-only String.
Bb243265.properties(en-us,office.12).gif NewFileTaskPane Returns a NewFile object that represents a document listed on the New File task pane. Read-only NewFile object.
Bb243265.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb243265.properties(en-us,office.12).gif Printer Returns or sets a Printer object representing the default printer on the current system. Read/write.
Bb243265.properties(en-us,office.12).gif Printers Returns the Printers collection representing all the available printers on the current system. Read-only Printers collection.
Bb243265.properties(en-us,office.12).gif ProductCode You can use the ProductCode property to determine the Microsoft Office Access 2007 globally unique identifier (GUID). Read-only String.
Bb243265.properties(en-us,office.12).gif References You can use the References property to access the References collection and its related properties, methods, and events. Read-only References collection.
Bb243265.properties(en-us,office.12).gif Reports You can use the Reports property to access the read-only Reports collection and its related properties.
Bb243265.properties(en-us,office.12).gif Screen You can use the Screen property to return a reference the Screen object and its related properties. Read-only.
Bb243265.properties(en-us,office.12).gif ShortcutMenuBar You can use the ShortcutMenuBar property to specify the shortcut menu that will appear when you right-click on the specified object. Read/write String.
Bb243265.properties(en-us,office.12).gif TempVars Returns the collection of TempVar objects. Read-only TempVars.
Bb243265.properties(en-us,office.12).gif UserControl You can use the UserControl property to determine whether the current Microsoft Office Access 2007 application was started by the user or by another application with Automation, formerly called OLE Automation. Read/write Boolean.
Bb243265.properties(en-us,office.12).gif VBE You can use the VBE property to return a reference to the current VBE object and its related properties. The VBE property of the Application object represents the Microsoft Visual Basic for Applications editor. Read-only VBE object.
Bb243265.properties(en-us,office.12).gif Version Returns a String indicating the version number of the currently installed copy of Microsoft Office Access 2007. Read-only.
Bb243265.properties(en-us,office.12).gif Visible Returns or sets whether a Microsoft Access application is minimized. Read/write Boolean