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

access database courses - open access data

Forum home » Delegate support and help forum » Microsoft Access Training and help » access database courses - Open access data entry record

access database courses - Open access data entry record

ResolvedVersion Standard

Gloria has attended:
Access Intermediate course
Access Advanced course

Open access data entry record

When opening in db in access I wish it to open on the next blank record rather than displaying record 1

RE: Open access data entry record

Hi Gloria,
Create your form as normal, format and arrange the fields, labels, headings etc. etc. If you have any existing data that you wish to populate it with now is the time to do so. You should save the form as something like "View or Edit Records"
In Datasheet view make a copy of the Form and name it something like "Add Reords". Open "Add Records" change to Design View and activate the Form Properties list. From the Data tab choose Data Entry and from the Drop Down choose "Yes". Close the Properties list, Save and close the Form.
In Datasheet View select Tools, Startup, in the Display Form/Page Text box, click the Drop Down options and Select "Add Records". Click OK, close the dialog box. Close the database. The next time you open the database, the "Add Records" form will open prompting you to enter a new record. Note: To view or edit any records you will need to open the "View or Edit Records" form. (perhaps a click button link on each would suffice).
Hope that helps and thank you for your posts.

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.