M
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.
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.