Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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]
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page