How to create an embedded macro?

image13An embedded macro is a macro that is not displayed in the Navigation Pane under Macros; it is stored in the event properties of forms, reports, or controls. This can make your access database easier to manage because you don’t need to monitor separate macro objects that contain macros for a form or a report. To create an embedded macro, follow the steps below:

  1. Open the form or report that will contain the macro in Design view or Layout view. To open a form or report, right-click it in the Navigation Pane, and then click Design View or Layout View.image7
  2. If the property sheet is not yet displayed, press F4 to display it. Continue reading “How to create an embedded macro?”

Microsoft Access 2016 Macros: Show All Macro Commands

Microsoft Access 2016 Macros: Show All Macro Commands

The great debate of whether to use Microsoft Access macros or the higher level of VBA code will linger on until the end of time (or realistically, Access is discontinued)!

In the meantime, most Access developers will continue to lean towards Access VBA but the majority of power users, self-taught Access designers will still embrace the ease of g using macros to automate their databases.

Microsoft Access 2016 Macros Show All Macro Commands

With the later versions of MS Access (post 2010), macros have become more powerful and flexible and with the added introduction of better web integration and the fact VBA Continue reading “Microsoft Access 2016 Macros: Show All Macro Commands”