M
Mark Andrews
I'm putting together a few applications in Access 2007 and I tend to use a
split form with a datasheet at the bottom and search functions, create new,
export to excel type functionality at the top of the form. The first column
of the datasheet is a hyperlink which is used to open a detail form showing
details.
Fairly similar to some of the Microsoft templates.
My question is about building filtering functionality into the application.
I like the built-in filtering functionality (using the little arrows on each
column) and have expanded that so the user can:
- filter various columns
- click a button a supply a name to save this filter (for use later)
However I would like to go further, let me give an example. One of my
applications is built around contacts and donations. I would like to allow
the user to see a list of contacts and donation summary items. However if I
change the datasheet to run off a query I lose the filtering capabilities.
Has anyone built their own "build a filter" system? Possibly where it
drives off a query and the types of fields present on the query (text,
numbers, dates different types of comparisions for each etc...). Example: I
want to build a filter to show contacts that donated > 0 in 2009, or show
contacts who donated > $5,000, or contacts who donated > 0 between 7/1/2009
and 7/31/2009 etc....
Note: this will be used in the runtime environment in the long run.
Thanks in advance,
Mark
split form with a datasheet at the bottom and search functions, create new,
export to excel type functionality at the top of the form. The first column
of the datasheet is a hyperlink which is used to open a detail form showing
details.
Fairly similar to some of the Microsoft templates.
My question is about building filtering functionality into the application.
I like the built-in filtering functionality (using the little arrows on each
column) and have expanded that so the user can:
- filter various columns
- click a button a supply a name to save this filter (for use later)
However I would like to go further, let me give an example. One of my
applications is built around contacts and donations. I would like to allow
the user to see a list of contacts and donation summary items. However if I
change the datasheet to run off a query I lose the filtering capabilities.
Has anyone built their own "build a filter" system? Possibly where it
drives off a query and the types of fields present on the query (text,
numbers, dates different types of comparisions for each etc...). Example: I
want to build a filter to show contacts that donated > 0 in 2009, or show
contacts who donated > $5,000, or contacts who donated > 0 between 7/1/2009
and 7/31/2009 etc....
Note: this will be used in the runtime environment in the long run.
Thanks in advance,
Mark