access training - Old Data Entry

Resolved · Low Priority · Version Standard

Mon 22 Jan 2007, 09:57 Delegate Julie said...

Julie has attended:
Access Introduction course

Old Data Entry

How can we make ex pupil data available but read only .

Mon 22 Jan 2007, 10:31 Trainer Richard said...

RE: Old Data Entry

Create a form from a query with Ex Pupil data in it.
Go to the Design view of the form
Double click on the top left square of the form to get the properties box.
Click on the DATA tab.
Set "Allow Filters, Allow Additions, Allow Edits, Allow Deletions" to NO.

Save and test in form view

This will allow the user to view the information, but not make any changes.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips