Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Search tool

Discussion in 'Information Technology' started by MikeP, Jul 28, 2006.

Tags:
  1. MikeP

    MikeP
    Expand Collapse
    Guest

    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.
     
  2. Loading...

    Similar Threads Forum Date
    Seeking a More Intuitive Search Tool (washingtonpost.com) Interfaith Dialogues Mar 27, 2005
    Sikh News Indian American Couple Donates For Sikh, Punjabi Culture Research In US Breaking News Aug 19, 2016
    Soul Search By Swarn Singh Bains Book Reviews & Editorials May 25, 2016
    Harpal Singh Kumar Cancer Researcher Knighted By Queen Elizabeth II Sikh Personalities Jan 5, 2016
    Movies Ashdoc's Movie Review---dozakh In Search Of Heaven ( 2015 ) Theatre, Movies & Cinema Apr 6, 2015

  3. Danny J. Lesandrini

    Danny J. Lesandrini
    Expand Collapse
    Guest

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

    Danny J. Lesandrini
    dlesandrini@hotmail.com
    http://amazecreations.com/datafast


    "MikeP" <MikeP@discussions.microsoft.com> wrote ...
    > 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.
    >
     

Share This Page