VBA for Project

[Tasha]

Hi,

I am trying to customize my database using 2-4 filters at the same time.
However, when I run it, the Filters Over-ride each other and give me the
incorrect result.

Is there anyway to go about solving this problem?

I have read a book on VBA but it doesnt help. Is there a way of using VBA to
solve it?

Any Help would be Appreciated.
Thanks

 

[Jan De Messemaeker]

Hi Tasha,

First, you do not absolutely need VBA to apply a complex filter.
Though the Project Menu, Filtered For..., More Filters, New, you can create
your own filters using And/Or conditions.

Of course, this is also possible through VBA, if you prefer that road.
Personally, for a really complex filter, I make a siple one (with as only
condition Flag1 equals Yes) and for each task I set the value of Flag1
through VBA conditions.

But if you're not very familiar with VBA maybe you can try the More Filters
road first.
HTH

 

[Sarah]

Are you using a custom filter, or running individual filter? If you are
using individual filters, yes, they will override each other. However,
with a custom filter, you should be able to "tweak" your criteria to
get it to show you exactly what you want. If you provide your criteria
here, I'm sure someone will be able to help with the correct phrasing
in the custom filter.

SarahK

 

[Gérard Ducouret]

Hello Tasha,
Don't try to run several filters togother ! You must create a filter with
*all* your criteria.
Notice that in the Filter dialog box (Project / filter for / More filter /
New...) there is a column where you can pick a AND or a OR operator.
In front of such operator, you can skip a row for the following condition:
this row appars greyed. It generates a hierarchy in your tests.

All filters can be ran by a VBA procedure. It's usefull when there are a lot
of tests which are waiting for values from the user.