Welcome to SPN

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

Sign Up Now!

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
    >
    >
    >
     

Share This Page