Welcome to SPN

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

Sign Up Now!

Missing Something Obvious

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

  1. Wayne Wengert

    Wayne Wengert
    Expand Collapse
    Guest

    Using Access 2003 I am trying to create a text field that uses Lookup with a
    set of hard coded selections but I cannot get it set up. The Lookup tab
    selections only list existing table names. How do I create a static list of
    optional values? The Help indicates you can do it but I can't find the
    "How".
     
  2. Loading...

    Similar Threads Forum Date
    Pacific Oil slicks spotted in search for missing Malaysia Airlines plane (Live updates) Breaking News Mar 8, 2014
    Heritage The curious case of Maharaja's 'missing' painting History of Sikhism Oct 29, 2013
    India Half of the missing children in 2013 remain untraced in India Breaking News Sep 3, 2013
    Note to admin: Missing post Literature Jul 7, 2013
    Malaysia Missing woman found dead Breaking News Jul 3, 2013

  3. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    If you are using the Lookup Wizard, on the first screen select the second
    option, 'I will type in the values that I want'.

    To create a lookup list without using the wizard, on the Lookup tab in table
    design view change the Row Source Type to Value List, then go to the Row
    Source field but do not click the builder button. Just type in the values
    separated by semi-colons like so ...

    one;two;three

    Most experienced Access developers have a low opinion of lookup fields, see
    the following URL for some reasons why ...

    http://www.mvps.org/access/lookupfields.htm

    --
    Brendan Reynolds
    Access MVP

    "Wayne Wengert" <wayneSKIPSPAM@wengert.org> wrote in message
    news:eyUV9mQmGHA.3600@TK2MSFTNGP02.phx.gbl...
    > Using Access 2003 I am trying to create a text field that uses Lookup with
    > a set of hard coded selections but I cannot get it set up. The Lookup tab
    > selections only list existing table names. How do I create a static list
    > of optional values? The Help indicates you can do it but I can't find the
    > "How".
    >
     
  4. Wolfgang Kais

    Wolfgang Kais
    Expand Collapse
    Guest

    Hello Wayne.

    Wayne Wengert wrote:
    > Using Access 2003 I am trying to create a text field that uses Lookup
    > with a set of hard coded selections but I cannot get it set up.
    > The Lookup tab selections only list existing table names.


    That's because you did not change the RowSourceType.

    > How do I create a static list of optional values?
    > The Help indicates you can do it but I can't find the "How".


    Try the following:
    Select the field you want to reate a lookup column for.
    Select "Lookup wizard..." in the list of datatypes for that field.
    Step through the wizard pages to create a static list.
    After finishing the wizard, verify the results on the lookup tab.

    Many experts (not me) advise not to use lookup fields at the table
    level because in datasheet view you (in other cases) may see data that
    isn't actually stored in the table you opened (you only store a key) but
    that is stored in another table (the lookup table).
    I don't have a problem with this, because users that might misinterpret
    the data displayed in datasheet view must not use datasheets but forms
    and reports in my databases. Once having configured lookup fields in
    a table, it's easy to create such a control in a form or report by simply
    dragging and dropping the field from the field list.

    --
    Regards,
    Wolfgang
     
  5. Kernow Girl

    Kernow Girl
    Expand Collapse
    Guest

    Hi Wayne - if it's in a field already set up, change the Row Source Type to
    Value List; then delete anything in the Row Source and enter your static list
    there with a semi-colin between each value. - ie Dr.;Mr.;Miss;Mrs.;Ms.. If
    you use the Lookup Wizard when creating the field in the table, on the very
    first screen choose the bottom option - I will type in the values I want.
    Hope this helps

    Yours -- Dika
    "Wayne Wengert" wrote:

    > Using Access 2003 I am trying to create a text field that uses Lookup with a
    > set of hard coded selections but I cannot get it set up. The Lookup tab
    > selections only list existing table names. How do I create a static list of
    > optional values? The Help indicates you can do it but I can't find the
    > "How".
    >
    >
    >
     
  6. Wayne Wengert

    Wayne Wengert
    Expand Collapse
    Guest

    Thanks. That was sure not intuitive for me!

    Wayne

    "Brendan Reynolds" <brenreyn@discussions.microsoft.com> wrote in message
    news:OVFuDwQmGHA.4816@TK2MSFTNGP03.phx.gbl...
    > If you are using the Lookup Wizard, on the first screen select the second
    > option, 'I will type in the values that I want'.
    >
    > To create a lookup list without using the wizard, on the Lookup tab in
    > table design view change the Row Source Type to Value List, then go to the
    > Row Source field but do not click the builder button. Just type in the
    > values separated by semi-colons like so ...
    >
    > one;two;three
    >
    > Most experienced Access developers have a low opinion of lookup fields,
    > see the following URL for some reasons why ...
    >
    > http://www.mvps.org/access/lookupfields.htm
    >
    > --
    > Brendan Reynolds
    > Access MVP
    >
    > "Wayne Wengert" <wayneSKIPSPAM@wengert.org> wrote in message
    > news:eyUV9mQmGHA.3600@TK2MSFTNGP02.phx.gbl...
    >> Using Access 2003 I am trying to create a text field that uses Lookup
    >> with a set of hard coded selections but I cannot get it set up. The
    >> Lookup tab selections only list existing table names. How do I create a
    >> static list of optional values? The Help indicates you can do it but I
    >> can't find the "How".
    >>

    >
    >
     
  7. Wayne Wengert

    Wayne Wengert
    Expand Collapse
    Guest

    Thanks. That helps.

    Wayne

    "Wolfgang Kais" <firstoffirstname.lastname@gmx.de> wrote in message
    news:e98IU2QmGHA.3504@TK2MSFTNGP04.phx.gbl...
    > Hello Wayne.
    >
    > Wayne Wengert wrote:
    >> Using Access 2003 I am trying to create a text field that uses Lookup
    >> with a set of hard coded selections but I cannot get it set up.
    >> The Lookup tab selections only list existing table names.

    >
    > That's because you did not change the RowSourceType.
    >
    >> How do I create a static list of optional values?
    >> The Help indicates you can do it but I can't find the "How".

    >
    > Try the following:
    > Select the field you want to reate a lookup column for.
    > Select "Lookup wizard..." in the list of datatypes for that field.
    > Step through the wizard pages to create a static list.
    > After finishing the wizard, verify the results on the lookup tab.
    >
    > Many experts (not me) advise not to use lookup fields at the table
    > level because in datasheet view you (in other cases) may see data that
    > isn't actually stored in the table you opened (you only store a key) but
    > that is stored in another table (the lookup table).
    > I don't have a problem with this, because users that might misinterpret
    > the data displayed in datasheet view must not use datasheets but forms
    > and reports in my databases. Once having configured lookup fields in
    > a table, it's easy to create such a control in a form or report by simply
    > dragging and dropping the field from the field list.
    >
    > --
    > Regards,
    > Wolfgang
    >
     
  8. Wayne Wengert

    Wayne Wengert
    Expand Collapse
    Guest

    Thanks. he entering a list separated by semicolons was the step I was
    missing.


    "Kernow Girl" <KernowGirl@discussions.microsoft.com> wrote in message
    news:828F5198-F908-4A8F-B2A1-092DAB9BE9AA@microsoft.com...
    > Hi Wayne - if it's in a field already set up, change the Row Source Type
    > to
    > Value List; then delete anything in the Row Source and enter your static
    > list
    > there with a semi-colin between each value. - ie Dr.;Mr.;Miss;Mrs.;Ms.. If
    > you use the Lookup Wizard when creating the field in the table, on the
    > very
    > first screen choose the bottom option - I will type in the values I want.
    > Hope this helps
    >
    > Yours -- Dika
    > "Wayne Wengert" wrote:
    >
    >> Using Access 2003 I am trying to create a text field that uses Lookup
    >> with a
    >> set of hard coded selections but I cannot get it set up. The Lookup tab
    >> selections only list existing table names. How do I create a static list
    >> of
    >> optional values? The Help indicates you can do it but I can't find the
    >> "How".
    >>
    >>
    >>
     
  9. Kernow Girl

    Kernow Girl
    Expand Collapse
    Guest

    Hi Wayne - now that you know how to set up a static list Lookup Table I would
    just say that it's always best to use a Table/Query Combo Box. Even if it's
    only a couple of items I've found that it so much simpler that a static list.
    First you always have open the field and alter the list by hand, which makes
    it very difficult and dangerous if it's someone not yourself doing that.
    Having set up many a screen for my users to edit the Lookup Tables, even
    something as simple as a Yes/No list is easy in a table. The other advantage
    is that if you set up a new Data Base you can simply import all the tables
    you use in your Combo Boxes, not having to enter the static list again.
    Hope this made sense and incourages you not to set up static lists --- yours
    Dika

    "Wayne Wengert" wrote:

    > Using Access 2003 I am trying to create a text field that uses Lookup with a
    > set of hard coded selections but I cannot get it set up. The Lookup tab
    > selections only list existing table names. How do I create a static list of
    > optional values? The Help indicates you can do it but I can't find the
    > "How".
    >
    >
    >
     
  10. Wayne Wengert

    Wayne Wengert
    Expand Collapse
    Guest

    Thanks.
    Sounds like good advice.

    Wayne

    "Kernow Girl" <KernowGirl@discussions.microsoft.com> wrote in message
    news:3F298569-45D5-498A-8F0E-45D157C6660E@microsoft.com...
    > Hi Wayne - now that you know how to set up a static list Lookup Table I
    > would
    > just say that it's always best to use a Table/Query Combo Box. Even if
    > it's
    > only a couple of items I've found that it so much simpler that a static
    > list.
    > First you always have open the field and alter the list by hand, which
    > makes
    > it very difficult and dangerous if it's someone not yourself doing that.
    > Having set up many a screen for my users to edit the Lookup Tables, even
    > something as simple as a Yes/No list is easy in a table. The other
    > advantage
    > is that if you set up a new Data Base you can simply import all the tables
    > you use in your Combo Boxes, not having to enter the static list again.
    > Hope this made sense and incourages you not to set up static lists ---
    > yours
    > Dika
    >
    > "Wayne Wengert" wrote:
    >
    >> Using Access 2003 I am trying to create a text field that uses Lookup
    >> with a
    >> set of hard coded selections but I cannot get it set up. The Lookup tab
    >> selections only list existing table names. How do I create a static list
    >> of
    >> optional values? The Help indicates you can do it but I can't find the
    >> "How".
    >>
    >>
    >>
     

Share This Page