|
Run the Search Manager
Professional from any form button or event. It can filter a form, display
matching records or change the row source of a list/combo box. You can even
use the Search Manager Pro's generic datasheet form to search any table or
query. These forms can be opened from any button on your data entry or
display form or can be opened from any event in your form. It can filter a
form, display matching records or change the row source of a list/combo box.
They can be run separately or can interact together to give you the most
custom search interface possible. All interfaces are
customizable with little or no programming!
Search Manager Professional features
include:
- Find any records in your tables using the Search
dialogs
- Define an unlimited number of search types using
our table driven technology
- Use the interfaces without any design changes to
a table or query
- Use all interfaces without any programming
changes
- Call the search form multiple times without
changing the search form
- Save and retrieve frequently used search types
- Create complex query statements with ease
- Call them from a form and return a filtered
version of the form
- Use them with a combo box or list box on a form
and change the row source
- Open the Advanced interface or the Simple
interface to search tables and queries using a generic datasheet form
- Use complex criteria like ‘between inclusive’,
‘between exclusive’, ‘contains’, etc.
- Automatically fill in dates specified as today,
first of the month, end of the month, etc.
- Display a pop-up calendar to make date selection
easy
- Call them from a report to filter a report
- Source code included
- Use royalty free in your applications
New to Search Manager Professional
If you have previously purchased a copy of
the EZ Search Manager, you can upgrade to the Search Manager Professional
for only $149 for a Single Developer license. Here's what's new in Search
Manager Professional:
- Three new search
engines
- Simple Search - creates a filter or
independently searches
- Smart Select - multiple smart search
selections
- Total Search - search within multiple
tables
- Enhancements to
Advanced Search
- Can be used to Filter reports
- Can be used with the Report Manager
Professional
- Has new auto-fill option to enable or
disable filling the Value combo box
- Works with new Generic Datasheet
- On-line Help
- Enhancements to Smart
Search
- Not limited to 8 definitions,
unlimited definitions now possible
- Remembers the most frequently used
searches and displays them in order
- Adds a new argument so key field can
be set to a form control
- When building a SQL string, the column
widths can be automatically set
- On-line Help
The Search Manager contains six
different search interfaces that provide different functionality based on a
particular situation. (click on the image to enlarge the view)
 Smart Search
– The Smart Search dialog allows you to define
multiple searches for your form by simply entering a few fields in a table.
When your user selects a search type, a list of all records is displayed
based on the fields and sort order you specify. When your user selects a
record, they return to the form they were originally on and depending on
your coding, either sees one record in a filtered form or the specific
record in an unfiltered form. The Smart Search will remember the most
frequently selected searches and display those the next time the form is
opened. For example, if there is one search that is used most of the time,
this search is displayed first each time you open a smart search interface.
 Advanced Search
– The Advanced Search dialog provides a
powerful and flexible search interface. With it you can find just about
anything using simple or complex criteria. The criteria you enter is done
with very easy to use selection fields and the interface takes care of all
the syntax that is necessary. An unlimited number of searches can be saved
and retrieved. Searches are saved by name with the criteria and the
table/query they are based on. This dialog is modeled after the Microsoft
Office advanced file search dialog. Users who are familiar with this type of
dialog will find it easy to use.
 Flex Search
– This type of search allows you to use a
single form for all your form searching needs. It gives you the flexibility
to search for one or all of the fields listed. You can search using partial
or exact keywords as well as adding operands to your searches. The user can
even change the search options on the fly. An example of the Flex Search
interface is displayed below.
 Simple Search - The
Simple Search interface can be used to create a filter for a form, form
control, or report. You can also use this type of search to search for data
independently from a form or report and view data using a generic form. The
Simple Search interface is a simplified version of the Advanced
Search interface. Up to 12 different criteria lines can be specified.
Smart Select - The
Smart Select interface has the same look and feel as the Smart Search, but
the Smart Select allows for multiple selections. The Smart Select
will remember the most frequently selected searches and display those the
next time the form is opened. For example, if there is one search that is
used most of the time, this search is displayed first each time you open a
smart select interface.
 Total Search - The
Total Search interface can be used to search for data within multiple
tables in a database. You can choose to search only linked tables, only
local tables, or all tables. You must also specify a data type and value to
search for.
|
