[AccessD] Datasheet Filters

[Rocky Smolin]

This will be useful as I'll need to know what the active filters are in
order to fashion a SQL statement to do the totals and averages.  Again,
something I've never used in 25 years of Access development.Thanks for that.

r

On Sun, Mar 12, 2023 at 7:01 PM Ryan W <wrwehler at gmail.com> wrote:

> Rocky,
>  The datasheet form should use .FilterOn (True or False) to tell you
> whether it's filtered, and the .Filter property to show what's filtered:
>
>
> ?Forms!Form1!t.form.filteron
> True
> ?forms!form1!t.form.filter
> ((([Table1 subform].[Field1]="foo_zip") AND ([Table1 subform].[ID]=1))) AND
> ([Table1 subform].[Color]="vbBlack")
>
> On Sun, Mar 12, 2023 at 6:41 PM Rocky Smolin <rockysmolin2 at gmail.com>
> wrote:
>
> > Dear List(s):
> >
> > I have a subform in datasheet format on a main form.  Several of the
> fields
> > on the subform are currency fields.
> >
> > The client wants sums and averages on several of those fields. I
> explained
> > that you can't do that with a datasheet but that in the footer of the
> > parent form I could give him all that data but the sum and average won't
> > line up under its column.  No problem for him.  He's happy with the data
> on
> > the footer.
> >
> > Since they will be using the filters on the datasheet fields to
> > restrict the data to just that they're interested in, that, obviously,
> will
> > change the values of the sum and averages as they apply different
> filters.
> >
> > What I need then is a way to see what the filters are, and generate a sql
> > statement with those filters as the source of the sums and averages.
> >
> > Q: Is there a way to poll the filters on those fields? I don't know of
> one.
> > But I'll bet there is one.
> >
> > MTIA
> >
> > Rocky
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>