Ms Access Continuous Form After Inserting New Row

• Remove From My Forums

Is there a way to add new entries at top of continuous forms vs. the bottom?

• Question

• Hi,

  I'm running Access 2003, 2007, and 2010 on Windows XP, Vista, and 7.

  I have a couple of working continuous form screen.  To add a new record, I have to scroll to the bottom records / form and then add my new entries.

  Is there anyway to have a new record entered a the top of the form.  As each new entry is added, I would like the old row to drop one line and a new record added to the current line so I can continue my data entry.  It would be like Inserting a new line in Word or Excel.

  Failing that, is there a way I can programmatically take the user to the last row in the continous form so that can add a new entry?

  Thanks,

  Dennis

  ---

  Dennis Solis

Answers

• Dennis,

      If you wish to enable the user to add fresh records at top of a form (irrespective of the sort order in force), combined with an otherwise normal display of records, my sample db namedAddDataAtTop might be of interest to you. It is available at Rogers Access Library. Link:

      The sample is in Access 2000 file format and covers continuous as well as datasheet forms. A brief description is given below.

  Best wishes,
  A.D. Tejpal
  ------------

  AddDataAtTop (Sample Db)

  Brief Description

  =====================

        This database demonstrates three styles of data entry at top of a subform -

  (a) Continuous Form Display (Using Command Button) -

          Data is entered via unbound text boxes in subform header, using command button on the parent form. Freshly added Record is highlighted in green, while other recent records added in current session are shown in orange.

  (b) Datasheet Display (Using Command Button) -

          On clicking the command button on parent form, fresh blank record (highlighted in green) is presented at the top of subform for enabling data entry. Recent records added in current session are shown in orange.

  (c) Datasheet Display (Auto - No command button) -

          On opening the main form, user is presented with fresh blank record (highlighted in green) at the top of subform. As soon as data entry commences in this record, its back color changes to yellow, while another fresh blank record (in green) is offered at top. All other recent records added in current session are shown in orange.

          (Note: This approach could be adapted suitably for a continuous form as well)

  =========================

  ----- Original Message -----

  Newsgroups: Msdn.en-US.accessdev

  Sent: Wednesday, February 02, 2011 22:18

  Subject: Is there a way to add new entries at top of continuous forms vs. the bottom?

  Hi,

  I'm running Access 2003, 2007, and 2010 on Windows XP, Vista, and 7.

  I have a couple of working continuous form screen.  To add a new record, I have to scroll to the bottom records / form and then add my new entries.

  Is there anyway to have a new record entered a the top of the form.  As each new entry is added, I would like the old row to drop one line and a new record added to the current line so I can continue my data entry.  It would be like Inserting a new line in Word or Excel.

  Failing that, is there a way I can programmatically take the user to the last row in the continous form so that can add a new entry?

  Thanks,

  Dennis

  ---

  A.D. Tejpal

  • Marked as answer by Thursday, February 10, 2011 9:45 AM

• There are several ways to use a command button that will jump to the new record at the bottom.  There's even a command button wizard that will do it for you.

  There is no automatic feature that puts the new record at the top of a form.  You can kind of fake it with a subform, by adding a second subform with just one row directly above the data subform.  Base both subforms on the same record source and set the one row subform's DataEntry to Yes and the first subform's AllowAdditions property to No.  But that's a lot of fooling around and IMO, not worth the effort.

  • Marked as answer by Bessie Zhao Thursday, February 10, 2011 9:45 AM

roushneash1957.blogspot.com

Source: https://social.msdn.microsoft.com/Forums/office/en-US/a91313f6-7da5-45d7-ab6e-3b861cc88550/is-there-a-way-to-add-new-entries-at-top-of-continuous-forms-vs-the-bottom?forum=accessdev

Share this post