ACC2000: How to Create a Data Access Page to Open to New Records Only (262453)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q262453
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).

SUMMARY

Sometimes you may want a data access page to open in data entry mode and to allow users to add only new records. This article shows you how to create such a data access page.

MORE INFORMATION

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

  1. Open the sample database Northwind.mdb.
  2. In the Database window, click Pages under Objects, and then click New.
  3. In the New Data Access Page dialog box, click AutoPage: Columnar, click Customers in the Choose the table or query where the object's data comes from box, and then click OK.
  4. On the View menu, click Design View.
  5. If the property sheet is not displayed, click Properties on the View menu.
  6. With the property sheet open, click Select Page on the Edit menu.
  7. Click the Data tab in the property sheet. Change the DataEntry property to True.
  8. On the View menu, click Page View. Note that the data access page opens to a new record.

REFERENCES

For more information about creating data access pages, click Microsoft Access Help on the Help menu, type create a data access page in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbDAP KB262453
©2004 Microsoft Corporation. All rights reserved.