ACC2000: Macro Actions Is Replaced with Comments in Design View (280373)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q280373
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

When you open a Microsoft Access 2000 macro in a Design view, you notice that certain actions have been replaced with comments.

CAUSE

Access 2002 has new macro actions that are not available in Access 2000. Macro actions that are new in Access 2002 do not appear in Design view of a macro in Access 2000. Instead, the new actions appear as comments in Access 2000.

RESOLUTION

To see the macro actions, open the file in Microsoft Access 2002.

STATUS

This behavior is by design.

MORE INFORMATION

Because you can use Access 2002 to design objects in Access 2000 file format, it is possible to create a macro that contains macro actions that are only available in Access 2002. When you later open this macro in Access 2000, the new macro action is unavailable, and a comment appears as a placeholder for the Access 2002-specific macro action.

Steps to Reproduce the Behavior

  1. In Access 2002, open any Access 2000 database or project.
  2. Create a new macro.
  3. Enter the following information into this new macro:
       Macro Name Condition  Action
   --------------------------------------
   A1                    MsgBox
   A2                    CopyDatabaseFile

   A1 Action Arguments
   ---------------------------------
   MsgBox
   Message: Getting ready to copy...
   Beep: Yes
   Type: None
   Title: Copy File

   A2 Action Arguments
   ---------------------------------------------
   CopyDatabaseFile
   Database File Name: C:\My Documents\My DB.mdb
   Overwrite Existing File: Yes
   Disconnect All Users: No
  4. Save the macro as Macro1, close the macro, and then close the database or project.
  5. In Access 2000, reopen the same database or project.
  6. Open the Macro1 macro in Design view. Note that the action for A1 (MsgBox) is still available. However, the action for A2 is blank, and there is a comment to indicate that an Access 2002-specific action (CopyDatabaseFile) is not available to Access 2000 users.
Modification Type:MinorLast Reviewed:7/13/2004
Keywords:kbprb KB280373
©2004 Microsoft Corporation. All rights reserved.