98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · 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.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Label printingYou 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 |