[AccessD] Remembering place on a datasheet

Don,

    Current Record method can misfire if field value in a sorted column has been updated. In such a situation use of bookmark property is more common.

    Sometimes, even the use of bookmark property fails to give consistent results. In such a case one might opt for navigating to the desired record - using its primary key value.

Regards,
A.D.Tejpal
--------------
  ----- Original Message ----- 
  From: Don Elliker 
  To: accessd at databaseadvisors.com 
  Sent: Wednesday, May 21, 2003 20:57
  Subject: Re: [AccessD] Remembering place on a datasheet


  I assume datasheet works like continuous form and if so, you can get the CurrentRecord prop of the recordsource and save it. Then use the docmd.gotorecord ,acgoto (I think) then the value you saved from the CurrentRecord. You could also , depending on what your doing, save the SelTop value and goto that.
  Ja?
  _D





  "Things are only free to the extent that you don't pay for them." 
  >From: "Mike and Doris Manning" 
  >Reply-To: accessd at databaseadvisors.com 
  >To: 
  >Subject: [AccessD] Remembering place on a datasheet 
  >Date: Wed, 21 May 2003 10:20:45 -0400 
  > 
  >I have created a datasheet for my users that works really well. The problem 
  >is that some users may have about 200 lines on there sheet. Whenever the 
  >datasheet requeries, the record pointer floats back to the top instead of 
  >remaining on the line the user was working with. 
  > 
  >Anybody got any suggestions for how can I sneakily return the user back to 
  >line they were working on to get around the requery problem? 
  > 
  >Doris Manning 
  >Database Administrator 
  >Hargrove Inc. 
  >www.hargroveinc.com 
  > 
  >_______________________________________________ 
  >AccessD mailing list 
  >AccessD at databaseadvisors.com 
  >http://databaseadvisors.com/mailman/listinfo/accessd 
  >Website: http://www.databaseadvisors.com 


------------------------------------------------------------------------------
  Help STOP SPAM with the new MSN 8 and get 2 months FREE* 


------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030522/2e606859/attachment-0001.html>