access+course+training - open new record opening

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

Forum 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

resolvedResolved · 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.


 

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips


Server loaded in 0.09 secs.