473,320 Members | 2,012 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,320 software developers and data experts.

Multiple Filter

11 Byte
Hey Guys,

I've created a query with employees vacations with the following columns:
1) EmpID
2) Name
3) Business Area
4) leave Date
And then created a form that displays all vacations taken

And then in the form I created text boxes above each with the following names:

1) ID Filter
2) BArea Filter

What I want is to filter the form if an employee taken more than the number written in ID Filter box and when I chose a Business Area in BArea Filter Box it filters by both parameters

e.g. If I write 3 in the ID Filter I want the form to show the employees that have taken 3 or more days off
Nov 23 '20 #1
6 4033
isladogs
455 Expert Mod 256MB
See my answer to a similar question in this Bytes thread https://bytes.com/topic/access/answe...hin-date-range
Nov 23 '20 #2
Lou699
11 Byte
Sadly I couldn't find the part for the Afterupdate filter related to ID Filter

What I want is whenever I write a number it shows the employees that are repeated for that number or more
Nov 23 '20 #3
isladogs
455 Expert Mod 256MB
Surely ID will be an autonumber primary key field so you will not / cannot update it.

Presumably you are referring to selecting an ID field for filtering using a combo box or textbox

Anyway, the principle is the same as in the example apps in my link.
If you study that carefully, you should be able to adapt it for your purposes.
Nov 23 '20 #4
Lou699
11 Byte
The ID is a short text and I don't want to filter based on a certain ID
I want to filter based on the x number repeated so if I type 2 in the ID filter I want the form to filter for all the employees with 2 entries

And when visited the topic you've sent I couldn't find a related solution

Thanks
Nov 23 '20 #5
twinnyfo
3,653 Expert Mod 2GB
You would have to use an aggregate query to determine how many entries each employee has, and then go from there. You would join the aggregate query with the employees table.
Nov 30 '20 #6
isladogs
455 Expert Mod 256MB
See almost identical thread by the same OP here: https://bytes.com/topic/access/answe...-ids-using-vba
Nov 30 '20 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: emailtonitin | last post by:
I am facing a design issue in my code related to the filesystemwatcher's filter property. I figured out that the filter won't accept multiple patterns for eg. "*.txt, *.csv" don't work. To...
23
blyxx86
by: blyxx86 | last post by:
I am trying to filter multiple entries with only one search box. That way the user can type whatever they want and find all the values that contain what they enter. Private Sub...
2
by: amir | last post by:
How can I filter my database in Multiple way, I mean that I wana to filter st. like this: sm* *th* *er Please Help me on this matter Amir
12
daniel aristidou
by: daniel aristidou | last post by:
hi i was wondering if it is possible to filter multiple numbers of tables at the same time. the filter would be automatically applied ie. as in a query. However i want only one list to appear...
3
by: angi35 | last post by:
Working in Access 2000... I have a form with records for every employee. I'd like to create two command buttons so a user can filter the form for either 'only current' or 'only former' employees. I...
1
by: woodey2002 | last post by:
Hi Everyone and many thanks for your time.. I am trying to begin access and a bit of VBA i am enjoying it but I have a annoying problem I just can’t get any where on. My databse mostly includes...
8
by: munkee | last post by:
Hi everyone, I am using the following code adapted from Allen Browne: 'Purpose: This module illustrates how to create a search form, _ where the user can enter as many or few...
0
by: sarora02 | last post by:
I have to designe a web page using ASP & ODBC data connectivity to show extract data from Access table to show data in tabular form. I have to filter data based on 5 critaria 1. Display all records...
9
by: Hurumpf | last post by:
Hi I have a database that holds recipes and I would like to be able to filter, in or out, certain ingredients. For example show all recipes containing chicken or filter out all recipes containing...
9
by: ittechguy | last post by:
I have a problem I've been trying to fix for the past two weeks. I'm trying to create a search form which filters : --Customers first name, last name, organization, shop name, office symbol ...
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
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...
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: 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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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)...
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
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.