473,327 Members | 1,936 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,327 software developers and data experts.

Help with a form

I'm working on a form that generates a query that the user can export
(I'm not working with reports - just with queries). The form allows
the user to filter the data using several fields. One of the fields is
ethnicity. So you can generate data of just white employees, of just
asian, etc. One of the users has asked me if I can set up a new option
of selection just minorities (which would be maybe 6 out of the 7
fields). I've played around a bit with this, but I'm having difficulty
figuring out how to manipulate the form/query so that all but white
employees display (while still retaining the option of displaying just
one ethnicity).

Any suggestions. I'm not super technical, so if it involves lots of
programming, it might be over my head. Can follow some straightforward
code (case statements, if statements etc.)
Aug 4 '08 #1
4 1053
"Coll" <co*********@hotmail.comwrote in message
news:dc**********************************@x41g2000 hsb.googlegroups.com...
I've played around a bit with this, but I'm having difficulty
figuring out how to manipulate the form/query so that all but white
employees display (while still retaining the option of displaying just
one ethnicity).
Right-click on "white" then choose "filter excluding selection".

Keith.
www.keithwilby.com

Aug 4 '08 #2
On Aug 4, 9:33*am, "Keith Wilby" <h...@there.comwrote:
"Coll" <col_mcma...@hotmail.comwrote in message

news:dc**********************************@x41g2000 hsb.googlegroups.com...
I've played around a bit with this, but I'm having difficulty
figuring out how to manipulate the form/query so that all but white
employees display (while still retaining the option of displaying just
one ethnicity).

Right-click on "white" then choose "filter excluding selection".

Keith.www.keithwilby.com
Hi - the user is working on a form with a pull-down that currently
lists each ethnicity. They select the ethnicity and then a query is
displayed with the results. The users are not sophisticated enough to
use filter excluding - I'm trying to modify my form so that it will do
the filter excluding for them - just not sure how to get it to work
using the form & the query.
Aug 4 '08 #3
Coll wrote:
On Aug 4, 9:33 am, "Keith Wilby" <h...@there.comwrote:
>>"Coll" <col_mcma...@hotmail.comwrote in message

news:dc**********************************@x41g20 00hsb.googlegroups.com...

>>>I've played around a bit with this, but I'm having difficulty
figuring out how to manipulate the form/query so that all but white
employees display (while still retaining the option of displaying just
one ethnicity).

Right-click on "white" then choose "filter excluding selection".

Keith.www.keithwilby.com


Hi - the user is working on a form with a pull-down that currently
lists each ethnicity. They select the ethnicity and then a query is
displayed with the results. The users are not sophisticated enough to
use filter excluding - I'm trying to modify my form so that it will do
the filter excluding for them - just not sure how to get it to work
using the form & the query.
You could use a pull down or listbox. In my form's header I may have
one or many items to filter on. In the AfterUpdate event of each item
to filter on I have this line in it
SetFilter
The sub then checks my items to filter on and builds a filter string. Ex:
Sub SetFilter
Dim strFilter As String
If Me.CheckActive then
strFilter = "OrderActive = True And "
Endif
...more filter checks
If strFilter "" Then
'remove trailing "And"
strFilter = Left(strFilter,Len(strFilter)-5)
Endif
Me.Filter = strFilter
Me.FilterOn = (strFilter "")
End Sub
Aug 4 '08 #4
"Coll" <co*********@hotmail.comwrote in message
news:b6**********************************@m44g2000 hsc.googlegroups.com...
The users are not sophisticated enough to use filter excluding
So you're saying that your users aren't capable of using the right mouse
button?

Aug 5 '08 #5

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

Similar topics

1
by: GrelEns | last post by:
hello, i had a trouble with re that i didn't understand (this is a silly example to show, to parse html i use sgmllib) : having this string : >>> s = """<form name="test" method="post"...
6
by: James Walker | last post by:
Can some one help I get an error of 'checkIndate' is null or not an object can someone please help. I can't work out why Thanks in advance James <form> <td height="24" colspan="7"...
5
by: Craig Keightley | last post by:
Please help, i have attached my page which worksin IE but i cannnot get the drop down menu to fucntion in firefox. Any one have any ideas why? Many Thanks Craig ...
0
by: Pat Patterson | last post by:
I'm having serious issues with a page I'm developing. I just need some simple help, and was hoping someone might be able to help me out in here. I have a form, that consists of 3 pages of...
2
by: chanchito_cojones | last post by:
hi there, I am needing some help with a database I am putting together. The database works off of a main Form, which then has buttons on it that will open up other forms. The problem I am having...
5
by: Steve Patrick | last post by:
Hi All You guys are my last hope, despite spending money on books and hours reading them I still can not achieve the results I need. I have designed a database in Access 2000 based on 1 table,...
5
by: TD | last post by:
Hey All, I am hooking up our custom html (.chm) help file to our Access xp application, and, despite reading several posts and manuals on this, I still have a gap in my understanding... OK, so...
1
by: Michael D. Reed | last post by:
I am using the help class to display a simple help file. I generated the help file using Word and saving it as a single page Web page (.mht extension). I show the help file with the following...
4
by: jerry.ranch | last post by:
Say, on a data entry form a "HELP" cmbBUTTON that bounces the user off to word file that has help, or is there some other way to do it (like a label object with help on another form) Thanks...
10
by: 60325 | last post by:
This is the page where I collect the data in drop-down boxes with values of 1-10 and send it to a submitted page to do calculations. Example: Employee1 TeamScore(1-10) Employee2 ...
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...
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: 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...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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: 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...

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.