Re: sum([TakesTooLong])

Tech-Archive recommends: Fix windows errors by optimizing your registry

Try the current event!

Jesse Aufiero wrote:
Adding a textbox to the footer of my continuous form in order to provide a
total dollar figure for one of the columns has become problematic. Even
when the form is filtered to show only a few records, access takes a very
long time to calculate the total. A sql trace (the back-end db is on sql
server 2000) reveals that the database is being hit once for every record in
order to come up with the total. As a result, I'd like some advice on how
to do this another way...

I'm thinking that the best way to force access to handle the summing on the
client machine, is to make use of the recordsetclone method, and then simply
have my form code iterate through the rows in the clone to handle the
summing on the client machine. The trouble is, i don't know what event to
hook into to do this. I'll want to trigger the code each time the user
filters the form in a different way. I tried using the ApplyFilter event,
but this event fires BEFORE access retreives the new filtered recordset.
Any ideas? I'm open to other well thought out suggestions.

Thanks!

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200609/1

.

Relevant Pages

  • sum([TakesTooLong])
    ... I'm thinking that the best way to force access to handle the summing on the ... client machine, is to make use of the recordsetclone method, and then simply ... have my form code iterate through the rows in the clone to handle the ... filters the form in a different way. ...
    (microsoft.public.access.forms)
  • Re: Band splitting
    ... summing my filter kernels resulted in a delayed ... If the filters form a perfect reconstruction pair, ... coefficients (which are also the impulse responses of the filters) ...
    (comp.dsp)
  • Re: Please help with a serious issue
    ... There should never be any reason why the users should be trying to ... Filters on client side cursors are in memory on the client machine and should ...
    (borland.public.delphi.database.ado)