Access Application Menu

The Access Application menu in Code VBA provides comprehensive access to the Microsoft Access Application object and its related automation features. It is more elaborate than the Excel version, offering specialized submenus for working with forms, reports, queries, tables, and other Access-specific objects. Each submenu helps you insert correct and ready-to-run VBA code for common Access tasks.

Access Application Menu

Overview

The menu is organized by object type and task category. Each main entry opens a submenu with commands that insert the corresponding DoCmd or object-based VBA statements. This structure makes it easy to find the right code for any Access automation scenario.

Main Menu Groups

  • Form - Access to commands for opening, closing, and navigating forms. Submenu includes OpenForm, ActiveForm, Close, Browse to Form, Change View, and links to Tutorials and Library. Example: DoCmd.OpenForm FormName:="Invoice".
  • Report - Commands for opening, printing, and exporting reports. Includes OpenReport, OutputTo, and PrintOut actions.
  • Query - Tools for running, opening, and managing queries. Includes OpenQuery, RunSQL, and TransferDatabase.
  • Table - Access to table-level operations such as opening, linking, or importing tables.
  • Data - Commands for exporting, importing, and transferring data between Access and external sources.
  • Record - Tools for navigating and editing records, including GoToRecord, FindRecord, and RunCommand actions.
  • Filter - Commands for applying and removing filters, and building criteria expressions. Includes ApplyFilter, RemoveFilter, and BuildCriteria.

Methods and Properties

Below the object-specific groups, the menu lists methods and properties of the Access Application object. Selecting one inserts the corresponding VBA statement, such as Application.CurrentProject or DoCmd.RunCommand.

Find

The Find command opens the Code VBA Find Procedure tool, allowing you to locate procedures related to Access objects or keywords. See: Find Procedure.

Library

The Library entry provides access to reusable code snippets for Access automation. These snippets include common patterns for opening forms, running queries, and managing data. See: VBA Code Reuse.

Object-Returning Members

The lower part of the menu lists Application members that return objects, such as CurrentProject, CurrentData, and CodeProject. Selecting one inserts code that declares and sets a variable of the corresponding type.

Single Object Members

This group includes members that return a single object reference, such as ActiveForm, ActiveDatasheet, or ActiveReport. These allow you to work directly with the currently active object without declaring additional variables.

Together, these menu sections make the Access Application menu a powerful tool for inserting correct, context‑aware VBA code for Access automation.