[AccessD] New Record Appearing on Top

A.D.Tejpal adtp at touchtelindia.net
Tue Aug 16 09:27:37 CDT 2005


Julie,

    My sample db named AddDataAtTop might be of interest to you. It is available at Rogers Access Library (other developers library). Link - http://www.rogersaccesslibrary.com

    The sample 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.

    You could adapt the underlying approach suitably, for your specific needs.

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

  ----- Original Message ----- 
  From: Julie Reardon-Taylor 
  To: accessd at databaseadvisors.com 
  Sent: Tuesday, August 16, 2005 19:05
  Subject: [AccessD] New Record Appearing on Top


  I have seen this question posted before and cannot remember the response.  A client has asked that the "new" record in a continuous form appear at the top.  I know that Access doesn't work that way.....but is there a way to do this?

  Julie Reardon-Taylor
  PRO-SOFT OF NY, INC.
  44 Public Square Suite #5
  Watertown, NY 13601
  Phone/Fax: (315) 785-0319
  www.pro-soft.net



More information about the AccessD mailing list