ACC2000: Name Appears Twice in Display Form/Page List

ID: Q199803

The information in this article applies to:

Microsoft Access 2000

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

The Display Form/Page list in the Startup dialog box may contain the same name twice.

CAUSE

There is a form and a data access page with the same name.

RESOLUTION

Method 1

Give each object a unique name so that you can distinguish one item from another in the Display Form/Page list.

Method 2

Use the following steps to create a macro that will open the appropriate object each time that you open the database.

In the Database window, click Macros under Objects, and then click New.

Create one of the following macros:


   Macro to Open a Form
   ----------------------------------------

      Action
      -------------------------
      OpenForm

      Action Arguments
      -------------------------
      Form Name: <form name>
      View: Form

      -or-

   Macro to Open a Data Access Page
   --------------------------------

      Action
      -------------------------
      OpenDataAccessPage

      Action Arguments
      ----------------------------------
      Data Access Page Name: <page name>
      View: Browse

On the File menu, click Save As. In the Save Macro '<name>' To box, type AutoExec, and then click OK.

MORE INFORMATION

The name of the form should appear first in the Display Form/Page list; however, the "Resolution" section provides two preferred methods to workaround this issue.

Steps to Reproduce Behavior

Create a new database named Form_Page.mdb.

In the Database window, click Pages under Objects, and then click New.

In the New Data Access Page dialog box, click OK.

On the File menu, click Save As. In the Save Page '<name>' To box, type Startup, and then click OK. Click Save.

On the File menu, click Close.

In the Database window, click Forms under Objects, and then click New.

In the New Form dialog box, click OK.

On the File menu, click Save As. In the Save Form '<name>' To box, type Startup, and then click OK.

On the File menu, click Close.

On the Tools menu, click Startup.

Click the arrow of the Display Form/Page list. Note that you cannot determine which item is the form and which is the page.

Additional query words: DAP prb differentiate

Keywords : kbdta AccDAP DAPProb
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb