Re: Grid stalling?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dave Tiffany (dtiffany_at_nospam.com)
Date: 03/25/05


Date: Fri, 25 Mar 2005 18:12:59 -0500

Fred,

Tried it in the real world and it runs great. It did in fact slow the
query down a little, but with the resulting cursors I'm likely to get,
(0 to 1000 records) the query speed is insignificant compared to the
improvement in grid behavior.

Thanks again for the lesson. I'm always amazed at what I don't know
about this product and how much there is available here.

Dave

Fred Taylor wrote:
> It's all a bit of "slight of hand" of Rushmore. It can return the result
> set faster as a filter. Using the NOFILTER keyword can take longer (for the
> SELECT) as it now actually has to pull the records into a cursor file. The
> grid would be faster because no filter is involved. So, as in all things in
> life, it's a trade off.
>



Relevant Pages

  • Please Help: Cannot UPDATE a table based on a query
    ... the above would be an UPDATE query not *code* as you indicated ... "Gina Whipp" wrote: ... then filter the records to get even more specific records. ...
    (microsoft.public.access.formscoding)
  • Re: Update Query based on Current Recordset
    ... Gina Whipp ... 2010 Microsoft MVP (Access) ... can base your update query on this. ... I opened the Properties dialog of the form and looked at the Filter ...
    (microsoft.public.access.formscoding)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... and have the query point to the combo box to get its value. ... the same filtered recordset every time. ... choose themselves what fields to filter on. ... Set MyRS = MyDB.OpenRecordset" ...
    (microsoft.public.access.formscoding)
  • Re: Update Query based on Current Recordset
    ... let's make the UPDATE query control that. ... I opened the Properties dialog of the form and looked at the Filter row. ... "Gina Whipp" wrote: ... UPDATE tblData SET tblData.ThreatStatus = Closed WHERE ...
    (microsoft.public.access.formscoding)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... in the criteria cell in the graphical query builder. ... use as the source in the routine. ... the same filtered recordset every time. ... choose themselves what fields to filter on. ...
    (microsoft.public.access.formscoding)