473,323 Members | 1,574 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Customizing Filters Discussion

Hi all. The folks at my current project are obsessed with creating
customized filters. I tried showing and telling them about Filter By
Selection and Filter By Form which will probably outdo any
functionality of what we customize but no luck. It's a bit annoying
on one hand but at the same time keeps me busy - can't complain.

The first, more simple task is to select one of about 8 sales reps,
select a filter of >=1000 on one column and >0% on another, all
applied at once. I'm not sure how the code would look or what
approach to take. Some of my experimenting didn't allow me to select
all three at once - it was one or the other.

The second issue is - is this really the way to go. I'm sure once
some of the main concepts are down, customizing text boxes and option
groups are a breeze. Are there certain commands which are commonly
used? Is there programming in which I can replicate the functionality
of Filter By Selection and Filter By Form which I could make more user
friendly and place in the header of the form.

Alot of the resources I have been using seem to assume you would use
the pre-made filter commands. fun, fun, fun.
Jeff
Nov 12 '05 #1
1 1426
I assume we are talking about filtering a data source for something? A
query? So what is not working in an SQL like

SELECT * FROM MyTable WHERE SalesRep = "John Doe" AND NumHappyCustomers
= 1000 AND PercentOfReturns > 0
I guess using the term "filtering" without the target object is throwing
me off. In my simple mind, "filtering" pertains to a report, form, etc.
Pavel

jeffgeorge wrote:
Hi all. The folks at my current project are obsessed with creating
customized filters. I tried showing and telling them about Filter By
Selection and Filter By Form which will probably outdo any
functionality of what we customize but no luck. It's a bit annoying
on one hand but at the same time keeps me busy - can't complain.

The first, more simple task is to select one of about 8 sales reps,
select a filter of >=1000 on one column and >0% on another, all
applied at once. I'm not sure how the code would look or what
approach to take. Some of my experimenting didn't allow me to select
all three at once - it was one or the other.

The second issue is - is this really the way to go. I'm sure once
some of the main concepts are down, customizing text boxes and option
groups are a breeze. Are there certain commands which are commonly
used? Is there programming in which I can replicate the functionality
of Filter By Selection and Filter By Form which I could make more user
friendly and place in the header of the form.

Alot of the resources I have been using seem to assume you would use
the pre-made filter commands. fun, fun, fun.

Jeff

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: VR | last post by:
I am trying to embed a check box into a FlexGrid's cell, but having a problem when I start scrolling the grid. Here is my MyCheckBox class... class MyCheckBox : CheckBox { void Init (...
4
by: Piotr Strycharz | last post by:
Hi I'm wondering what is the best way to design localized applications. The SDK says I should use ResourceManager and satellite assemblies. However, there is a severe pitfall doing this. The...
6
by: TJO | last post by:
Below is some sample code that fades div tags that is not working in IE 6.0.29 on xp sp2. Can anyone help see why the if(ie5) document.getElementById(divID).filters.alpha.opacity lines are not...
1
by: Dieter Vanderelst | last post by:
Hello, I'm trying to access the Filters-Dll provided by the filters-project (http://filters.sourceforge.net/index.htm). Following the advice I got from the Python list -thank you for that-, I...
10
by: ballpointpenthief | last post by:
How good is the C language for implementing maps, filters and accumulators? SCHEME programmers would be able to pass procedures as arguments quite easily, whereas C programmers would - I guess -...
6
by: smcdonald | last post by:
I have a report that opens up using a pretty complex query. I then pop up a form with combo boxes so the user can apply a filter to the existing report and then refresh the report. I need to export...
0
by: kucol | last post by:
Hi guys, I wanted to ask you for help as I am struggling with it second evening already... I have got tables DEVICES and PARTS. One device can consist of multiple parts. But... I have...
5
by: favor08 | last post by:
have a mainform called PendingsMain and a subform called PendingsSub. You can filter the subform by different filters and this works fine. i want to create a report that will print out the...
0
by: CatchSandeepVaid | last post by:
We all know that one-to-one associations are non-lazly fetched but during this fetching the filters are not applied. I debugged hibernate code and found that hibernate finally calls...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.