Welcome to SPN

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

Sign Up Now!

Finding specific records

Discussion in 'Information Technology' started by souchie40, Nov 8, 2005.

  1. souchie40

    souchie40
    Expand Collapse
    Guest

    Hi everyone,

    Like to say what a great group this is and thanks for all the help in the
    past.

    However moving on here is my dilema today, I have a form that is based on a
    query from several tables, this query can have hundres/thousands of records,
    what I would like to do is do a search on a specific field and jump to that
    records form, what I am thinking is along the lines of the record navigation
    button for find but when I press the command button on my form it defaults to
    the required field and parameters leaving the user to enter the search text
    criteria.

    MTIA
     
  2. Loading...

    Similar Threads Forum Date
    The Salmon Story, Finding Home Sikh Sikhi Sikhism Jul 29, 2016
    Sikhi Guru Nanak's Methodology Of Finding Truth Sikh Sikhi Sikhism Jan 1, 2016
    Movies Ashdoc's movie review---Finding Fanny ( English version ) Theatre, Movies & Cinema Sep 15, 2014
    S Asia Sikh Girls in Afghanistan Face Difficulty in Finding Mr. Right Breaking News Jul 31, 2013
    Finding True Guru Gurmat Vichaar Jan 7, 2012

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Have a look at Filter By Form (Records ... Filter ... Filter By Form). The
    interface may be just what you are looking for. Once selected from the menu,
    simply fill in any field and click on the Filter button (the funnel)
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "souchie40" <souchie40@discussions.microsoft.com> wrote in message
    news:1AC200E0-2944-4D17-A2A2-36CD0E34757D@microsoft.com...
    > Hi everyone,
    >
    > Like to say what a great group this is and thanks for all the help in the
    > past.
    >
    > However moving on here is my dilema today, I have a form that is based on

    a
    > query from several tables, this query can have hundres/thousands of

    records,
    > what I would like to do is do a search on a specific field and jump to

    that
    > records form, what I am thinking is along the lines of the record

    navigation
    > button for find but when I press the command button on my form it defaults

    to
    > the required field and parameters leaving the user to enter the search

    text
    > criteria.
    >
    > MTIA
     
  4. souchie40

    souchie40
    Expand Collapse
    Guest

    Yes that would do what I want , but is there a way to run 'filter by form and
    apply filter' from code and again to remove filter

    TIA

    "Arvin Meyer [MVP]" wrote:

    > Have a look at Filter By Form (Records ... Filter ... Filter By Form). The
    > interface may be just what you are looking for. Once selected from the menu,
    > simply fill in any field and click on the Filter button (the funnel)
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > "souchie40" <souchie40@discussions.microsoft.com> wrote in message
    > news:1AC200E0-2944-4D17-A2A2-36CD0E34757D@microsoft.com...
    > > Hi everyone,
    > >
    > > Like to say what a great group this is and thanks for all the help in the
    > > past.
    > >
    > > However moving on here is my dilema today, I have a form that is based on

    > a
    > > query from several tables, this query can have hundres/thousands of

    > records,
    > > what I would like to do is do a search on a specific field and jump to

    > that
    > > records form, what I am thinking is along the lines of the record

    > navigation
    > > button for find but when I press the command button on my form it defaults

    > to
    > > the required field and parameters leaving the user to enter the search

    > text
    > > criteria.
    > >
    > > MTIA

    >
    >
    >
     
  5. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Sure:

    DoCmd.RunCommand acCmdFilterByForm
    DoCmd.RunCommand acCmdApplyFilterSort
    Docmd.RunCommand acCmdRemoveFilterSort

    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "souchie40" <souchie40@discussions.microsoft.com> wrote in message
    news:01B8E0E4-D9E2-418D-90DA-C8B8329A64E5@microsoft.com...
    > Yes that would do what I want , but is there a way to run 'filter by form

    and
    > apply filter' from code and again to remove filter
    >
    > TIA
    >
    > "Arvin Meyer [MVP]" wrote:
    >
    > > Have a look at Filter By Form (Records ... Filter ... Filter By Form).

    The
    > > interface may be just what you are looking for. Once selected from the

    menu,
    > > simply fill in any field and click on the Filter button (the funnel)
    > > --
    > > Arvin Meyer, MCP, MVP
    > > Microsoft Access
    > > Free Access downloads
    > > http://www.datastrat.com
    > > http://www.mvps.org/access
    > >
    > > "souchie40" <souchie40@discussions.microsoft.com> wrote in message
    > > news:1AC200E0-2944-4D17-A2A2-36CD0E34757D@microsoft.com...
    > > > Hi everyone,
    > > >
    > > > Like to say what a great group this is and thanks for all the help in

    the
    > > > past.
    > > >
    > > > However moving on here is my dilema today, I have a form that is based

    on
    > > a
    > > > query from several tables, this query can have hundres/thousands of

    > > records,
    > > > what I would like to do is do a search on a specific field and jump to

    > > that
    > > > records form, what I am thinking is along the lines of the record

    > > navigation
    > > > button for find but when I press the command button on my form it

    defaults
    > > to
    > > > the required field and parameters leaving the user to enter the search

    > > text
    > > > criteria.
    > > >
    > > > MTIA

    > >
    > >
    > >
     
  6. souchie40

    souchie40
    Expand Collapse
    Guest

    Hi,

    But How would I get it to pause between 'filter by form' and 'apply filter'
    so that the user can enter the required criteria

    TIA

    "Arvin Meyer [MVP]" wrote:

    > Sure:
    >
    > DoCmd.RunCommand acCmdFilterByForm
    > DoCmd.RunCommand acCmdApplyFilterSort
    > Docmd.RunCommand acCmdRemoveFilterSort
    >
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > "souchie40" <souchie40@discussions.microsoft.com> wrote in message
    > news:01B8E0E4-D9E2-418D-90DA-C8B8329A64E5@microsoft.com...
    > > Yes that would do what I want , but is there a way to run 'filter by form

    > and
    > > apply filter' from code and again to remove filter
    > >
    > > TIA
    > >
    > > "Arvin Meyer [MVP]" wrote:
    > >
    > > > Have a look at Filter By Form (Records ... Filter ... Filter By Form).

    > The
    > > > interface may be just what you are looking for. Once selected from the

    > menu,
    > > > simply fill in any field and click on the Filter button (the funnel)
    > > > --
    > > > Arvin Meyer, MCP, MVP
    > > > Microsoft Access
    > > > Free Access downloads
    > > > http://www.datastrat.com
    > > > http://www.mvps.org/access
    > > >
    > > > "souchie40" <souchie40@discussions.microsoft.com> wrote in message
    > > > news:1AC200E0-2944-4D17-A2A2-36CD0E34757D@microsoft.com...
    > > > > Hi everyone,
    > > > >
    > > > > Like to say what a great group this is and thanks for all the help in

    > the
    > > > > past.
    > > > >
    > > > > However moving on here is my dilema today, I have a form that is based

    > on
    > > > a
    > > > > query from several tables, this query can have hundres/thousands of
    > > > records,
    > > > > what I would like to do is do a search on a specific field and jump to
    > > > that
    > > > > records form, what I am thinking is along the lines of the record
    > > > navigation
    > > > > button for find but when I press the command button on my form it

    > defaults
    > > > to
    > > > > the required field and parameters leaving the user to enter the search
    > > > text
    > > > > criteria.
    > > > >
    > > > > MTIA
    > > >
    > > >
    > > >

    >
    >
    >
     
  7. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Opening Filter By Form pauses by itself. You would then enter your criteria
    and push another button to apply the filter.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "souchie40" <souchie40@discussions.microsoft.com> wrote in message
    news:67110FE1-F76E-48FE-8A73-7F0B6D93A4A1@microsoft.com...
    > Hi,
    >
    > But How would I get it to pause between 'filter by form' and 'apply

    filter'
    > so that the user can enter the required criteria
    >
    > TIA
    >
    > "Arvin Meyer [MVP]" wrote:
    >
    > > Sure:
    > >
    > > DoCmd.RunCommand acCmdFilterByForm
    > > DoCmd.RunCommand acCmdApplyFilterSort
    > > Docmd.RunCommand acCmdRemoveFilterSort
    > >
    > > --
    > > Arvin Meyer, MCP, MVP
    > > Microsoft Access
    > > Free Access downloads
    > > http://www.datastrat.com
    > > http://www.mvps.org/access
    > >
    > > "souchie40" <souchie40@discussions.microsoft.com> wrote in message
    > > news:01B8E0E4-D9E2-418D-90DA-C8B8329A64E5@microsoft.com...
    > > > Yes that would do what I want , but is there a way to run 'filter by

    form
    > > and
    > > > apply filter' from code and again to remove filter
    > > >
    > > > TIA
    > > >
    > > > "Arvin Meyer [MVP]" wrote:
    > > >
    > > > > Have a look at Filter By Form (Records ... Filter ... Filter By

    Form).
    > > The
    > > > > interface may be just what you are looking for. Once selected from

    the
    > > menu,
    > > > > simply fill in any field and click on the Filter button (the funnel)
    > > > > --
    > > > > Arvin Meyer, MCP, MVP
    > > > > Microsoft Access
    > > > > Free Access downloads
    > > > > http://www.datastrat.com
    > > > > http://www.mvps.org/access
    > > > >
    > > > > "souchie40" <souchie40@discussions.microsoft.com> wrote in message
    > > > > news:1AC200E0-2944-4D17-A2A2-36CD0E34757D@microsoft.com...
    > > > > > Hi everyone,
    > > > > >
    > > > > > Like to say what a great group this is and thanks for all the help

    in
    > > the
    > > > > > past.
    > > > > >
    > > > > > However moving on here is my dilema today, I have a form that is

    based
    > > on
    > > > > a
    > > > > > query from several tables, this query can have hundres/thousands

    of
    > > > > records,
    > > > > > what I would like to do is do a search on a specific field and

    jump to
    > > > > that
    > > > > > records form, what I am thinking is along the lines of the record
    > > > > navigation
    > > > > > button for find but when I press the command button on my form it

    > > defaults
    > > > > to
    > > > > > the required field and parameters leaving the user to enter the

    search
    > > > > text
    > > > > > criteria.
    > > > > >
    > > > > > MTIA
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >
     

Share This Page