Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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).

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


Keywords: KB262453, kbdap

↑ Back to the top

Article Info
Article ID : 262453
Revision : 2
Created on : 6/29/2004
Published on : 6/29/2004
Exists online : False
Views : 299