By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,445 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Help with a form

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
"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

P: n/a
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

P: n/a
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

P: n/a
"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 discussion thread is closed

Replies have been disabled for this discussion.