Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access

ResolvedVersion 2003

Patricia has attended:
Access Advanced course
Access VBA course

Access 2003

Can you alter a page property so that it only allows new records to be added?

Edited on Wed 9 Apr 2008, 16:17

RE: Access 2003

Hi Patricia

Yes you can.

1. Open the Page in design view

2. In the Header area click the down arrow

3. Select Group Level Properties

4. Turn AllowDeletions and AllowEdits to False leaving only AllowAdditions set to true.

Hope this helps

Carlos

Access tip:

Related tables

When you have related tables such as Customers and their Orders, the Customer table is the Primary table.

Open the Customers table in datasheet view and go to the Home Tab and Records group. Click on the More option and choose Subdatasheet and then click on Subdatasheet again. Now choose the related table (Orders) and click ok.

Now you can click the + symbol by each company to show the related orders.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.