Search tool

[MikeP]

Hi,
I made a database in access 2003 that can search a large table using
multiple criteria. Its composed of a form with multiple comboboxes with
queries built into them so the results are filtered down based on what is
entered into the other boxes. There is also a text string field which uses 2
separate queries to search the fields for specific text.

The data comes from 2 linked tables that are linked to an Infor database,
read only.

When I hit the search button in the form it runs an OpenQuery macro. I want
to be able to make the resulting query show up on top of the form, which
remains open. Right now the query pops up in the background and is covered by
the form.

Also I need to find a way to make a version of this search utility that
doesnt require Access. I'm not sure of the best way to make this into a web
based version or a standalone executable. The fiields are all unbound because
the linked table is read only, so I havent been able to save it as a DAP.

 

[Danny J. Lesandrini]

Mike:

First, it's more flexible from within Access to use VBA code instead of Macros
for doing what you describe. I've typically created a form and subform to allow
users to display a filtered recordset. The parent form has the selection criteria,
and the subform loads the resulting datasheet. This way, there is no "on top"
issues. However, you need to build the SQL for the sub form datasheet in code
and assign it to the RecordSource property.


As for the second question, this article might help you. I wrote this some time
ago and it uses VB and ADO to access a SQL Server database, but it wouldn't
be a huge leap to point it to Access.

http://www.databasejournal.com/img/TestADOSQL.jpg
http://www.databasejournal.com/features/mssql/article.php/1493921


There's another article coming out at DBJ later this month that shows how to
display any table from an ASP page. This is also a Non-Access approach to
showing data from an MDB file. Until that article comes out (in about a week)
you can view the code and demo of the app at my web site ...

http://amazecreations.com/showmethetable/ShowMeTheTable.asp


Database Journal has a lot of great articles for Access developers.
http://www.databasejournal.com/features/msaccess/

Hope this helps.