Welcome to SPN

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

Sign Up Now!

Auto suggest answer

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

  1. Sinatrasdame

    Sinatrasdame
    Expand Collapse
    Guest

    I'm creating a database of information of historical people related to the
    museum I work at. several of the fields will have the same value for multiple
    records. I want to get Access to suggest the value the same way that Exel
    does. As you type it suggests the rest in highlited text. Can I do this and
    if so how? Thanks
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Is Autocomplete Evil? Some Women Take A Hard Look at Google ! Breaking News Nov 7, 2013
    Sikh News AutoZone sued for firing Everett Sikh Breaking News Sep 29, 2010
    India Singh: Centre Ready To Give Kashmir Autonomy Breaking News Aug 11, 2010
    India Paste tariff cards behind driver’s seat: Transport dept to automen Breaking News Jul 21, 2010
    Gursharan Kaur: India's First Lady's Autobiography Sikh Personalities Jun 1, 2010

  3. ginnyk

    ginnyk
    Expand Collapse
    Guest

    Yes, you can get Access to do that. First, create a separate table of
    the possible values for that field. After that, it depends a little on
    what version of Access you're using and whether you're entering/editing
    your records directly into a table or using a form.
    If you're using a form, use a combo box control for the field. Set the
    RowSource property of the combo box to point to the list (table) of
    appropriate values.
     
  4. John Welch

    John Welch
    Expand Collapse
    Guest

    I agree with ginnyk - a combobox is probably the best answer for you. But,
    instead of creating a separate table for the possible values, you can just
    make the combo box row source be all the values that are currently in your
    existing table, like this:

    rowsource: select distinct artist from tblArtists order by artist
    limit to list: no

    "ginnyk" <glkmeyer@comcast.net> wrote in message
    news:1150493070.885907.195810@f6g2000cwb.googlegroups.com...
    > Yes, you can get Access to do that. First, create a separate table of
    > the possible values for that field. After that, it depends a little on
    > what version of Access you're using and whether you're entering/editing
    > your records directly into a table or using a form.
    > If you're using a form, use a combo box control for the field. Set the
    > RowSource property of the combo box to point to the list (table) of
    > appropriate values.
    >
     
  5. Sinatrasdame

    Sinatrasdame
    Expand Collapse
    Guest

    I could do that, but wouldn't I then have to enter a value before I could use
    it? I want to be able to both add new vlaues and be able to select others.

    "John Welch" wrote:

    > I agree with ginnyk - a combobox is probably the best answer for you. But,
    > instead of creating a separate table for the possible values, you can just
    > make the combo box row source be all the values that are currently in your
    > existing table, like this:
    >
    > rowsource: select distinct artist from tblArtists order by artist
    > limit to list: no
    >
    > "ginnyk" <glkmeyer@comcast.net> wrote in message
    > news:1150493070.885907.195810@f6g2000cwb.googlegroups.com...
    > > Yes, you can get Access to do that. First, create a separate table of
    > > the possible values for that field. After that, it depends a little on
    > > what version of Access you're using and whether you're entering/editing
    > > your records directly into a table or using a form.
    > > If you're using a form, use a combo box control for the field. Set the
    > > RowSource property of the combo box to point to the list (table) of
    > > appropriate values.
    > >

    >
    >
    >
     
  6. John Welch

    John Welch
    Expand Collapse
    Guest

    You said you wanted it to act like Excel, where if you start typing
    something that it has seen before, it will try to finish it for you. If you
    set the limit to list property of the combo box to "no" , then you will be
    able to add new values, but it will autofill a choice if it recognizes
    something you've entered previously.

    "Sinatrasdame" <Sinatrasdame@discussions.microsoft.com> wrote in message
    news:6B4E6CC3-669C-4C2C-8F8E-B4036FF33971@microsoft.com...
    >I could do that, but wouldn't I then have to enter a value before I could
    >use
    > it? I want to be able to both add new vlaues and be able to select others.
    >
    > "John Welch" wrote:
    >
    >> I agree with ginnyk - a combobox is probably the best answer for you.
    >> But,
    >> instead of creating a separate table for the possible values, you can
    >> just
    >> make the combo box row source be all the values that are currently in
    >> your
    >> existing table, like this:
    >>
    >> rowsource: select distinct artist from tblArtists order by artist
    >> limit to list: no
    >>
    >> "ginnyk" <glkmeyer@comcast.net> wrote in message
    >> news:1150493070.885907.195810@f6g2000cwb.googlegroups.com...
    >> > Yes, you can get Access to do that. First, create a separate table of
    >> > the possible values for that field. After that, it depends a little on
    >> > what version of Access you're using and whether you're entering/editing
    >> > your records directly into a table or using a form.
    >> > If you're using a form, use a combo box control for the field. Set the
    >> > RowSource property of the combo box to point to the list (table) of
    >> > appropriate values.
    >> >

    >>
    >>
    >>
     

Share This Page