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+course+training - Open new record on opening access
access+course+training - Open new record on opening access
Resolved · Low Priority · Version Standard
Gloria has attended:
Access Intermediate course
Access Advanced course
Open new record on opening access
When opening access how do you get access to automatically display a new record ready for entry, normally when it opens it goes straight to the first record
RE: open new record on opening access
Hi Gloria,
Pleased to receive your post, hope this helps...
Create your form as per normal, Format and arrange the Fields, Labels, Headings etc. etc.
If necessary you could populate it now with any data that you have currently. When the form is created and populated to your satisfaction, save it and name it something like "View Records".
In Datasheet view, make a copy of the Form (File, Copy; File Paste) name it something like "Add Records".
Open Add Records in Design view and activate the Form Properties list, Under the Data Tab, choose Data Entry and from the Drop Down arrow slect "Yes". Close the Properties pane and save the Form. Close the Form.
From the Database window select Tools, Startup, in the Display Form/Page option click the Drop Down and select your new form "Add Records", click OK.
The next time you open the Database, The "Add Records" form will open prompting you to add new records. If you wish to view all records, you will need to change to the "View Records" Form. (Perhaps place a button on the page to do this).
Hope that helped.
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:Closing form after a certain time periodTo make a form close automatically after a certain time period, you need to assign the close function to a macro. |