Re: Original Rows

From: Cor Ligthert (notfirstname_at_planet.nl)
Date: 07/05/04


Date: Mon, 5 Jul 2004 08:50:31 +0200

Hi Terry,

The question is for me, is *selecting* the rows from the tables, selecting
the rows with the latest values using the rowstatusfilter to select or is it
selecting the rows with the originalvalues.

I stay with the first because I only use the rowstatefilter as a filter to
select the rows.

When you use the dataview it gets a different behaviour because than it is
not only filtering however as well giving the originalrows, and that for my
much more strange to see.

However which one is right, you go probably for the last, I for the first.

I hope you see my point now?

Cor



Relevant Pages

  • Re: Original Rows
    ... it does not in fact support the full range of RowState enumerations. ... the RowState Filter does report correctly. ... > The question is for me, is *selecting* the rows from the tables, selecting ... > selecting the rows with the originalvalues. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Using check boxes to select items in a multi select list box
    ... This will be a single user situation, and if there are multiple users, they ... won't be trying to do data entry and filter records at the same time. ... Selecting and saving keywords works perfectly. ...
    (microsoft.public.access.forms)
  • Re: Autofilter-Filtered List Scan
    ... I tried the code you posted and I get inconsistent results depending on the filter setting. ... In the VisRng just created there maybe several rows and columns, ... For Each Cell in Visrng ... and selecting the not hidden rows is a big overhead and>> things ...
    (microsoft.public.excel.programming)
  • Re: gang remove blank rows
    ... After clicking filter on the Data menu, ... but Autofilter allowed me to select blanks and non-blanks. ... But by going back in to Autofilter and selecting Non-blanks I achieved the ...
    (microsoft.public.excel.misc)
  • Passing Query Parameters from form to another VBA subroutine
    ... I've got a form that lets the user filter a table full of ... name, address, location, bla bla) by ... selecting from values in six different fields - and am ... parameters for the underlying query. ...
    (microsoft.public.access.queries)