Remove filter selections

C

CindyF

hello quick question...
I have a form which I am using in filter by form mode. I use a lot of and
and or tabs for this, but am sick of having to delete each selection
individually when I want to filter again, and if I forget one my integrity is
affected. Is something that i can do that will clear all filter selections on
command? thank you (i am relatively new to access sorry* the easier the
better!!!)
 
6

'69 Camaro

Hi, CindyF/Scooter/Ben/Antonio/et cetera.

Try:

RunCommand acCmdClearGrid

P.S. What's with all the different names? I noticed you posted 29
questions while signing in with these four names:

http://www.microsoft.com/office/com...67db&dg=microsoft.public.access&lang=en&cr=US

There's no limit (or penalty) to the number of questions that one might ask
in the newsgroups. Familiar names generally get questions answered faster
than questions from unfamiliar names, so you may be better off just keeping
one persona. So ask as many questions as you want, Ben.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
W

Wayne Morgan

You could create a button that would set the form's Filter property to ""
when the button is clicked.

Example:
Me.Filter = ""
 
C

CindyF

Hey- thanks. I thought that I was using this servicxe to much and that I may
be unwelcome. Obviously not too good at deception either so I think I will
leave that to the movies. Thank you for helping me with my project, when I
started on this site I knew nothing of MS access and now I have a very
dynamic database and it has helped me progress within my job. Would be lost
without all of your input. So, I apologise and thank you.
 
6

'69 Camaro

Hi, Ben.
I thought that I was using this servicxe to much and that I may
be unwelcome.
Click to expand...

Actually, it's not a service. Volunteers answer the questions submitted
here and throughout
UseNet. Your questions are always welcome. We're happy to help you improve
your database whenever we can. And some day you may be able to return the
favor and answer questions posted by others. :)
Obviously not too good at deception
Click to expand...

It's a trick that people who have misbehaved in the newsgroups commonly use
to bypass having been plonked by those who answer questions. Newsreaders
check each message sender's E-mail address and block the plonked messages
from being downloaded to the newsreader. Change the displayed E-mail
address and future messages will get through, because the newsreader can't
identify the message as being from a formerly plonked user.

Of course, I'm not using an ordinary newsreader. I use Campaign, which
identifies questions that haven't yet been answered among hundreds of
newsgroups and also displays the questioner's history, like yours. Your
questions stand out like a sore thumb, just like the ones posted by Steve
Santus when he's pretending to be someone else. ;-)

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
 
Top