Looking for generic QBF template...

[AlexT.]

Folks

I'm looking for some sort of generic Query by Form UI, i.e. a very
typical form where the user would be able to select search criteria
and see the results in a list.

I have developed a few custom apps which are working relatively well
for this purpose but I now want to try a generic approach, i.e. hiding
as much as possible from the underlying database specifics to the
actual UI code.

I guess I can start something from scratch but I was wondering if
anyone would recommend some starting point / reference. Ideally
looking for something that uses the latest tricks of 2k7

I'm sure that google should be my friend but so far I haven't found
anything even remotely close to the above...

Any input most welcome

--alexT

 

[Allen Browne]

Here's one that illustrates how to create a flexible search:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
The downloadable example illustrates how to build a filter string from
whichever boxes the user entered critieria in, for different data types,
partial matches, date range, etc. The code is designed to make it easy to
add more criteria. The sample db applies the filter to the form, but you can
use exactly the same approach to apply a filter to a report.

If you only want to search on one field at a time, you could try this one:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
This consists of a combo (where you choose which field to search), and a
text box (where you enter the value to find.) It's copy'n'paste stuff (does
not need to be changed to work with different forms.)

 

[AlexT.]

Here's one that illustrates how to create a flexible search:

Thanks

--alextT