Welcome to SPN

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

Sign Up Now!

i have added a command button but how do i use it to search data?

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

  1. claire_t

    claire_t
    Expand Collapse
    Guest

    i have access 2003. i am trying to set up a database of customer information.
    I have designed a form but i just need to know how to search the form for a
    particular 1.
    i have added a command button i now need to know how to use this to search
    customer surnames. ie if i type in "Ta" it will bring up "Taylor", "Tanner"
    etc..
    please can comeone help! and in the simpliest, clearly explained way!
    thanks
     
  2. Loading...

    Similar Threads Forum Date
    USA AP Breaking News: Sikhs Added to Hate Crime Stats Breaking News Aug 3, 2013
    Opinion Singapore: Added Cultural Richness, MM Lee Breaking News Jul 4, 2010
    Commandments Blogs Jun 29, 2016
    General Meet Hari Singh Nalwa - The Sikh Commander Who Was The Most Feared Warrior In Afghanistan History of Sikhism Jun 23, 2016
    Opinion The rescue operations of Delhi’s Love commandos Breaking News Feb 2, 2013

  3. Sheila D

    Sheila D
    Expand Collapse
    Guest

    Hi Claire

    Probably the easiest way is to link your form to a query. In the criteria
    row under Surname type Like [Enter beginning of surname] & "*"

    When you open the form a box will appear with Enter beginning of surname (or
    wahtever you type inside the [] The "*" is a wild card which means the end of
    the name can be anything. HTH
    Sheila

    "claire_t" wrote:

    > i have access 2003. i am trying to set up a database of customer information.
    > I have designed a form but i just need to know how to search the form for a
    > particular 1.
    > i have added a command button i now need to know how to use this to search
    > customer surnames. ie if i type in "Ta" it will bring up "Taylor", "Tanner"
    > etc..
    > please can comeone help! and in the simpliest, clearly explained way!
    > thanks
     
  4. claire_t

    claire_t
    Expand Collapse
    Guest

    RE: i have added a command button but how do i use it to search da

    That works ok thanks but i have one more slightly dumb question. how do you
    link this query to my form?
    thanks

    "Sheila D" wrote:

    > Hi Claire
    >
    > Probably the easiest way is to link your form to a query. In the criteria
    > row under Surname type Like [Enter beginning of surname] & "*"
    >
    > When you open the form a box will appear with Enter beginning of surname (or
    > wahtever you type inside the [] The "*" is a wild card which means the end of
    > the name can be anything. HTH
    > Sheila
    >
    > "claire_t" wrote:
    >
    > > i have access 2003. i am trying to set up a database of customer information.
    > > I have designed a form but i just need to know how to search the form for a
    > > particular 1.
    > > i have added a command button i now need to know how to use this to search
    > > customer surnames. ie if i type in "Ta" it will bring up "Taylor", "Tanner"
    > > etc..
    > > please can comeone help! and in the simpliest, clearly explained way!
    > > thanks
     
  5. Sheila D

    Sheila D
    Expand Collapse
    Guest

    RE: i have added a command button but how do i use it to search da

    Hi Claire

    Open the form in Design View; without selecting any object on the form click
    the Properties button on the toolbar (the button with a hand on it) That
    should give you a dialogue box with the form properties. Go to the Data tab -
    the first property is Data Source. Clcik the drop down arraow and choose your
    query from the list. (Make sure that the query has all the fields in it that
    you currently have in your form)
    CLose the dialogue box then save and close your form.

    Good Luck - Sheila

    "claire_t" wrote:

    > That works ok thanks but i have one more slightly dumb question. how do you
    > link this query to my form?
    > thanks
    >
    > "Sheila D" wrote:
    >
    > > Hi Claire
    > >
    > > Probably the easiest way is to link your form to a query. In the criteria
    > > row under Surname type Like [Enter beginning of surname] & "*"
    > >
    > > When you open the form a box will appear with Enter beginning of surname (or
    > > wahtever you type inside the [] The "*" is a wild card which means the end of
    > > the name can be anything. HTH
    > > Sheila
    > >
    > > "claire_t" wrote:
    > >
    > > > i have access 2003. i am trying to set up a database of customer information.
    > > > I have designed a form but i just need to know how to search the form for a
    > > > particular 1.
    > > > i have added a command button i now need to know how to use this to search
    > > > customer surnames. ie if i type in "Ta" it will bring up "Taylor", "Tanner"
    > > > etc..
    > > > please can comeone help! and in the simpliest, clearly explained way!
    > > > thanks
     
  6. betwalk@gmail.com

    betwalk@gmail.com
    Expand Collapse
    Guest

    Re: i have added a command button but how do i use it to search da

    For a little more flexibility, the OP could also learn about placing
    combo box search tools on her forms. That way, if Claire needs to
    search more than one method, she can. She could have search tools for
    first names, last names, company names, etc.

    Just a thought...

    Betsy
     
  7. claire_t

    claire_t
    Expand Collapse
    Guest

    RE: i have added a command button but how do i use it to search da

    Thank you so much!that works great!!

    "Sheila D" wrote:

    > Hi Claire
    >
    > Open the form in Design View; without selecting any object on the form click
    > the Properties button on the toolbar (the button with a hand on it) That
    > should give you a dialogue box with the form properties. Go to the Data tab -
    > the first property is Data Source. Clcik the drop down arraow and choose your
    > query from the list. (Make sure that the query has all the fields in it that
    > you currently have in your form)
    > CLose the dialogue box then save and close your form.
    >
    > Good Luck - Sheila
    >
    > "claire_t" wrote:
    >
    > > That works ok thanks but i have one more slightly dumb question. how do you
    > > link this query to my form?
    > > thanks
    > >
    > > "Sheila D" wrote:
    > >
    > > > Hi Claire
    > > >
    > > > Probably the easiest way is to link your form to a query. In the criteria
    > > > row under Surname type Like [Enter beginning of surname] & "*"
    > > >
    > > > When you open the form a box will appear with Enter beginning of surname (or
    > > > wahtever you type inside the [] The "*" is a wild card which means the end of
    > > > the name can be anything. HTH
    > > > Sheila
    > > >
    > > > "claire_t" wrote:
    > > >
    > > > > i have access 2003. i am trying to set up a database of customer information.
    > > > > I have designed a form but i just need to know how to search the form for a
    > > > > particular 1.
    > > > > i have added a command button i now need to know how to use this to search
    > > > > customer surnames. ie if i type in "Ta" it will bring up "Taylor", "Tanner"
    > > > > etc..
    > > > > please can comeone help! and in the simpliest, clearly explained way!
    > > > > thanks
     
  8. claire_t

    claire_t
    Expand Collapse
    Guest

    Re: i have added a command button but how do i use it to search da

    well if you want to explain how to do this then i could try it. its for a
    cattery database so it could be usefull to search cat names also!
    so if you explain in simple way i would like to try to search multiple fields
    thanks

    "betwalk@gmail.com" wrote:

    > For a little more flexibility, the OP could also learn about placing
    > combo box search tools on her forms. That way, if Claire needs to
    > search more than one method, she can. She could have search tools for
    > first names, last names, company names, etc.
    >
    > Just a thought...
    >
    > Betsy
    >
    >
     
  9. betwalk@gmail.com

    betwalk@gmail.com
    Expand Collapse
    Guest

    Re: i have added a command button but how do i use it to search da

    I would encourage you to explore the uses of the combo box wizard. One
    of the options allows you to set up a drop down list from which the
    user makes a selection and that selection can move them to any desired
    record in the database. So, for instance, if you had a database of
    contact information, you could have one search combo for a LastName,
    FirstName search of the primary person, and another for LastName,
    FirstName of the spouse (sometimes those are different than the primary
    person), and yet another that could search by company name, etc.

    Here's how to explore this tool:

    1] Go to the design view of the form you are using to view your data.
    2] Be sure that your toolbox is showing.
    3] Be sure that the "wand" tool is engaged (it should look like it's
    pressed down)
    4] Click on the combo box tool and then click on any blank area of the
    form (remember that you can always move or resize the combo later)
    5] At this point the wizard should kick into action. On the first
    screen, the 3rd option is "find a record on my form based on the value
    I selected in my combo box". This is the option you want. Click the
    bullet for it.
    6] Click "next".
    7] The next screen lets you identify what field(s) the user will scroll
    through to find the record they want. For example, if you wanted a
    LastName, FirstName search, this is the screen that lets you identify
    those two fields. Add the desired fields to the "selected fields" list
    on the right side of the screen.
    8] Click the "next" button.
    9] The next screen shows you how the fields you selected will appear in
    the drop down combo box.
    10] Click the "next" button.
    11] Give your combo box a meaningful label.
    12] Click "Finish".

    Now play with the tool you have created. You will discover that some
    customizing will be necessary, but the basic tool will be in place.
    For instance, I always sort the list and supress duplicates. Once you
    have a combo box (or two!) in place, let us know and we can help with
    customizing.

    hth-

    Betsy
     

Share This Page