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

simple record search (or perhaps not so simple)

Discussion in 'Information Technology' started by Greg, Nov 18, 2005.

  1. Greg

    Greg
    Expand Collapse
    Guest

    i need to do a record search in a form but there are a few twists.

    1. this form is (by itself) simple and used for creating totally new records
    and entering them into a simple table (all fields are text, date or number)
    2. there is no unique field to any of these records
    3. the form has 9 fields, 5 of which are required for creating a record.
    4. the solution has to be super easy for the end-users of this database. i'm
    thinking of a command button that pops up a form that let's a person select
    up to 3 criteria (2 of which are one of the required fields mentioned earlier
    and 1 is not -- but i don't want to require any of them for this search so i
    need to allow for null values in the ones that they don't pick) and then
    searching the table for all records that match those criteria. then letting
    the user select which record they want to edit (i would need to know how to
    let a user select a record), then closing the popups and displaying the
    record in the original form, ready for editing.

    i can do the button to pop the 2nd form and the controls for that form
    (probably 2 text boxes and 1 combo box, if that matters) but dont' know how
    to DO the search, return another popup of results, select 1 and populate the
    1st form.
     
  2. Loading...

    Similar Threads Forum Date
    Grammer / Vyakarn Learn Simple & Easiest Gurbani Vyakaran/grammer From Prof. Maninderpal Singh Language, Arts & Culture Mar 9, 2015
    General Babaji Ranjit Singh Dhandrian Wale, Simple living high Thinking Hard Talk Sep 27, 2013
    Sikh Weddings Simple? No, they Are Indulged In Brahmanwad Questions and Answers Sep 15, 2012
    The One-Minute Mystic: Simple Things You Can Do to Stay Connected Spiritual Articles May 23, 2011
    Being a Simple Sikh (blog of a Prithihardkaur Sikh) Spiritual Articles Sep 13, 2010

  3. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    Have you tried going:

    records->Filter->Filter by form?

    The above will instantly transform your form into a "search form", and you
    can type values into any field..and it will search for you..

    Do give the above a try.....



    --
    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com
    http://www.members.shaw.ca/AlbertKallal
     
  4. Greg

    Greg
    Expand Collapse
    Guest

    initially, i did not know of this feature. when i tried it, it seems to be
    almost exactly what i want except that it's not exactly user-friendly enough.
    i mean, i can figure out how to do it, but the end users that i have in
    mind, i'm honestly not so sure. i know that they'd uderstand it if
    shown/told how to do it but that understanding wouldn't last for longer than
    a few weeks and this should really be something they'd need to use very
    seldomly. i'm not trying to insult my coworkers mind you, it's just that
    none of them have ever touched access before (neither had i, 6 weeks ago) and
    i want to make it fool proof.

    i also tried the wizard on that cmd button to construct a filter by form
    button but it wasn't the same thing. the wizard didn't use filter by form,
    it wanted user input for the search parameters. i really need this to be
    super easy to do. thanks.

    "Albert D.Kallal" wrote:

    > Have you tried going:
    >
    > records->Filter->Filter by form?
    >
    > The above will instantly transform your form into a "search form", and you
    > can type values into any field..and it will search for you..
    >
    > Do give the above a try.....
    >
    >
    >
    > --
    > Albert D. Kallal (Access MVP)
    > Edmonton, Alberta Canada
    > pleaseNOOSpamKallal@msn.com
    > http://www.members.shaw.ca/AlbertKallal
    >
    >
    >
     
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