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

resolvedResolved · Low Priority · Version 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:

Label printing

You can create a report in Access for printing labels All you have to do is is click New under the Reports object and then select Label Wizard and follow the steps

View all Access hints and tips


Server loaded in 0.08 secs.