Welcome to SPN

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

Sign Up Now!

Populate forms

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

Tags:
  1. Adrian Roberts

    Adrian Roberts
    Expand Collapse
    Guest

    Hi all
    I am very new at access, what I have is a database in which I enter all my
    data through a forms, when I need to search for a particular record I have
    to display the record in a new form, when I do these searches I need to see
    all the information on a client so instead of opening a new form can I enter
    the search criteria then have it display in the main form. I have about 10
    different search criteria and it seems pointless making 10 forms the same.
    Thanks for any help
    Ady
     
  2. Loading...

    Similar Threads Forum Date
    USA Akaal Takhat Forms Committee to Represent US Sikhs Breaking News Sep 13, 2013
    India Poll reforms on crash course Breaking News Sep 7, 2013
    General A Conversation about the Grammatical Forms of Raam and Simran Hard Talk Dec 1, 2011
    India Anna Says Fast Only "Suspended", Wants Electoral Reforms Breaking News Aug 28, 2011
    India India Announces $5 bn Aid for Africa, Seeks Support for UN Reforms Breaking News May 24, 2011

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 26 Jun 2006 18:46:09 +0100, "Adrian Roberts"
    <adrian.roberts@ntlworld.com> wrote:

    >Hi all
    >I am very new at access, what I have is a database in which I enter all my
    >data through a forms, when I need to search for a particular record I have
    >to display the record in a new form, when I do these searches I need to see
    >all the information on a client so instead of opening a new form can I enter
    >the search criteria then have it display in the main form. I have about 10
    >different search criteria and it seems pointless making 10 forms the same.
    >Thanks for any help
    >Ady
    >


    Have you tried using the very powerful "Filter By Form" technique?
    Open your data display form, and select Records... Filter by Form.

    You can then put criteria in one, two, or ten controls on the form,
    and Access will search for them.

    John W. Vinson[MVP]
     
  4. Adrian Roberts

    Adrian Roberts
    Expand Collapse
    Guest

    Hi
    Thanks for that I took a quick look and it may weel do the job, one of the
    criteria I have is to find all additions to the database after a certain
    date, would that work from this as well. I assume I can put buttons on the
    page to do the filter by form as other people can use it but I wanted to
    turn the toolbars off.

    Thanks
    Ady

    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    news:haf0a21nd0sosdg9obulj3955tvdunrs47@4ax.com...
    > On Mon, 26 Jun 2006 18:46:09 +0100, "Adrian Roberts"
    > <adrian.roberts@ntlworld.com> wrote:
    >
    >>Hi all
    >>I am very new at access, what I have is a database in which I enter all my
    >>data through a forms, when I need to search for a particular record I have
    >>to display the record in a new form, when I do these searches I need to
    >>see
    >>all the information on a client so instead of opening a new form can I
    >>enter
    >>the search criteria then have it display in the main form. I have about 10
    >>different search criteria and it seems pointless making 10 forms the same.
    >>Thanks for any help
    >>Ady
    >>

    >
    > Have you tried using the very powerful "Filter By Form" technique?
    > Open your data display form, and select Records... Filter by Form.
    >
    > You can then put criteria in one, two, or ten controls on the form,
    > and Access will search for them.
    >
    > John W. Vinson[MVP]
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 27 Jun 2006 07:42:13 +0100, "Adrian Roberts"
    <adrian.roberts@ntlworld.com> wrote:

    >Hi
    >Thanks for that I took a quick look and it may weel do the job, one of the
    >criteria I have is to find all additions to the database after a certain
    >date, would that work from this as well. I assume I can put buttons on the
    >page to do the filter by form as other people can use it but I wanted to
    >turn the toolbars off.


    You can (see the other responses in this thread) program a form to do
    this; and yes, you can put a criterion

    > #6/1/2006#


    in the date-added field to see all additions. (Of course you do need a
    date-added field in your table and appropriate methods to maintain
    it).

    John W. Vinson[MVP]
     

Share This Page