Profile PictureNifty Access
$9.99

Nifty Filter

1 rating
Add to cart

Nifty Filter

$9.99
1 rating

The Nifty Universal Filter was created in answer to this question on Access World Forums (AWF):- https://www.access-programmers.co.uk/forums/threads/search-form-by-field-yes-no.317953/#post-1768264 - I call it a universal filter because in the process of testing, I tested it against one of the MS "Northwind Database" Tables the "Products Table"... The products table had a checkbox to denote if a product has been discontinued. With a bit of faffing about I managed to get a combo-box setup which could interrogate this checkbox/Boolean field. By accident, I managed to create two distinct combo boxes, combo boxes with different characteristics. I could take advantage of these differences and the combos could be treated by the VBA code in a different manner. This Discovery allowed me to create the two types of combo box, one for returning a chosen value from in the combo and the other for deciding whether to show the Boolean values as "Yes" "No" or "ALL"...

Add to cart
Size
543 KB
Copy product URL

Ratings

5
(1 rating)
5 stars
100%
4 stars
0%
3 stars
0%
2 stars
0%
1 star
0%