Welcome to SPN

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

Sign Up Now!

search

Discussion in 'Information Technology' started by antonov, Nov 6, 2005.

Tags:
  1. antonov

    antonov
    Expand Collapse
    Guest

    Hello again... I need to create a search form in which I need to define a
    certain amount of parameters (Yes/No, if a certain textbox is empty, etc).
    Can it be done?
     
  2. Loading...

    Similar Threads Forum Date
    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
    Research Shows NFL Quarterbacks Play Better With Beards Business, Lifestyle & Leisure Nov 23, 2014

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Sat, 5 Nov 2005 22:40:40 +0100, "antonov" <antonov@dds.nl> wrote:

    >Hello again... I need to create a search form in which I need to define a
    >certain amount of parameters (Yes/No, if a certain textbox is empty, etc).
    >Can it be done?
    >


    Sure. Make it an unbound form (don't pick any table or query when you
    create it); let's say you call it frmCrit. Create a Query with
    criteria like

    Forms![frmCrit]![txtThis]

    It's handy to base a Form (for onscreen display) and/or a Report (for
    printing) based on this query, and put command buttons on frmCrit to
    open them.

    John W. Vinson[MVP]
     
  4. antonov

    antonov
    Expand Collapse
    Guest

    Hello John, thanks for your reply but I may need to be more specific.
    I need to create a form which will be opened by pressing a button in an
    existing form. I need to be able to find records in the open form, by
    inserting certain criteria. Let's say I want to see how many records are
    "no" (yes/no check Box) or how many records have 297 in a specific text
    box... or how many records have a specific weight in the weight textbox. I
    need to be able to find the record by inserting one or more criteria.
    I hope I don't come over too confused....
    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    news:t4jqm15ndvmjsq2csilml8dffd3f103uah@4ax.com...
    > On Sat, 5 Nov 2005 22:40:40 +0100, "antonov" <antonov@dds.nl> wrote:
    >
    >>Hello again... I need to create a search form in which I need to define a
    >>certain amount of parameters (Yes/No, if a certain textbox is empty, etc).
    >>Can it be done?
    >>

    >
    > Sure. Make it an unbound form (don't pick any table or query when you
    > create it); let's say you call it frmCrit. Create a Query with
    > criteria like
    >
    > Forms![frmCrit]![txtThis]
    >
    > It's handy to base a Form (for onscreen display) and/or a Report (for
    > printing) based on this query, and put command buttons on frmCrit to
    > open them.
    >
    > John W. Vinson[MVP]
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Sun, 6 Nov 2005 01:41:48 +0100, "antonov" <antonov@dds.nl> wrote:

    >Hello John, thanks for your reply but I may need to be more specific.
    >I need to create a form which will be opened by pressing a button in an
    >existing form. I need to be able to find records in the open form, by
    >inserting certain criteria.


    You can't find records in a Form. A Form doesn't contain records; a
    table does. The form is just a window, a tool to view the data.

    >Let's say I want to see how many records are
    >"no" (yes/no check Box) or how many records have 297 in a specific text
    >box... or how many records have a specific weight in the weight textbox.


    Do you want to FIND the records? Or do you want to COUNT the records?
    These are quite different requirements.

    >I need to be able to find the record by inserting one or more criteria.
    >I hope I don't come over too confused....


    Well, I hope I'm not coming over as too confusing!

    It SOUNDS like you want to just set the Filter property of the form,
    or use Filter by Form. Have you investigated this technique? Use the
    Filter by Form icon on the toolbar and see if this gets you what you
    want.

    John W. Vinson[MVP]
     
  6. antonov

    antonov
    Expand Collapse
    Guest

    John, the filter by form is exactely what I was looking for. Thanks for the
    hint
    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    news:efvqm1h6lrkmm710p2c3tnat1f0kgv56sq@4ax.com...
    > On Sun, 6 Nov 2005 01:41:48 +0100, "antonov" <antonov@dds.nl> wrote:
    >
    >>Hello John, thanks for your reply but I may need to be more specific.
    >>I need to create a form which will be opened by pressing a button in an
    >>existing form. I need to be able to find records in the open form, by
    >>inserting certain criteria.

    >
    > You can't find records in a Form. A Form doesn't contain records; a
    > table does. The form is just a window, a tool to view the data.
    >
    >>Let's say I want to see how many records are
    >>"no" (yes/no check Box) or how many records have 297 in a specific text
    >>box... or how many records have a specific weight in the weight textbox.

    >
    > Do you want to FIND the records? Or do you want to COUNT the records?
    > These are quite different requirements.
    >
    >>I need to be able to find the record by inserting one or more criteria.
    >>I hope I don't come over too confused....

    >
    > Well, I hope I'm not coming over as too confusing!
    >
    > It SOUNDS like you want to just set the Filter property of the form,
    > or use Filter by Form. Have you investigated this technique? Use the
    > Filter by Form icon on the toolbar and see if this gets you what you
    > want.
    >
    > John W. Vinson[MVP]
     

Share This Page