Nifty Search Form

Nifty Search Form

This Advanced but simple to use Search Form is unbelievably easy to set-up. Just create a query and a subform. Following the comprehensive Video Instructions, which demonstrate how to add this incredible utility to your database. Establish yourself as the “Go To” person in your organisation for database improvements! Nifty Access Drop in “Nifty Components” will quickly elevate you to “Power User Level!” 

Search Form Demo

Advanced Search Form

Video 1 (1:03)

Demonstration of the search forms features, in particular you have the option to search the beginning middle and ending of text formatting characters.

Video 1 (1:03)

Nifty Access YouTube Thumb Nail
Play Video

… …

Search Form - Setting it up

Search Form - Set-up

Video 2 (8:30)

In this Video I Demonstrate how to change the Form, from showing products to showing customers. I demonstrate the steps, and also some traps you might fall into in following this process.

Video 2 (8:30)

Nifty Access YouTube Thumb Nail
Play Video

… …

Search Form - Add a Field

Search Form - Add a Field

Video 3 (3:58)

In this video I demonstrate how easy it is to search another field. For example had a search on customer reference. Bear in mind that the “Nifty Search Form” is only designed to search “text”. It’s not designed to search numbers, dates, – things like that…

Video 3 (3:58)

Nifty Access YouTube Thumb Nail
Play Video

… …

Search Form - Blast Through!

Search Form - Blast Through!

Video 4 (4:12)

In this video I’m just going to do a quick “Blast Through” – see how quickly I can set up the “Nifty Search Form” from scratch… This is me being surprisingly quiet, except for a few Mouse clicks…

Video 4 (4:12)

Nifty Access YouTube Thumb Nail
Play Video

… …

Search Form Example

Search Form Example

Video 5 (00:57)

In helping a member of Access World Forums with a Search Problem, I demonstrated how it could be done with the Nifty Access Search Form. You can see the original question at this link on Access World Forums (AWF):- Multi field search-box and you can see how my Search Form answer to the question by watching this YouTube video.

Video 5 (00:57)

Nifty Access YouTube Thumb Nail
Play Video

The original question posted, and the various answers given by the excellent members of Access World Forums can be seen in this thread here:-

… …

Nifty Search Form Adding NULL

Nifty Search Form Adding NULL

Video 6 (2:42)

This is the first of two videos looking at the code behind the Search Form. It will be of interest to anyone who wants to modify the search form for their own purposes. It will be of little interest to anyone else! This code came about through a special request from one of my customers. As requested, I have updated the “Nifty Search Form”… The “Nifty Search Form” now searches for “Exact Matches” and “Null values” This video shows the necessary Adjustment to the SQL Statement produced by the the Search Form VBA code. I made the video as an aide de memoire to record the modifications I made and the decisions Behind Those modifications.

Video 6 (2:42)

Nifty Access YouTube Thumb Nail
Play Video

… …

Search Form with NULL and EXACT

Search Form with NULL and EXACT

Video 7 (4:12)

This is the Second Video concerning the recent alteration to the “Search Form” Code. This video will be helpful to anyone who wants to alter the code behind the Search Form. It will be of little interest to anyone else! In answer to a customer request I have updated the “Nifty Search Form”… The “Nifty Search Form” now searches for “Exact Matches” and “Null values” This video shows the necessary Adjustment to the SQL Statement produced by the the Search Form VBA code. I made the video as an aide de memoire to record the modifications I made and the decisions Behind Those modifications.

Video 7 (4:12)

Nifty Access YouTube Thumb Nail
Play Video

… …

This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.

Do you need a hand in the right direction?

You are in the right place.