Missing Something Obvious

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12060-missing-something-obvious.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12060
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".



*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12060
the following URL for some reasons why ...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12060

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

--
Brendan Reynolds
Access MVP

"Wayne Wengert" 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".
>

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12060
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12060
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

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12060
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12060
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".
>
>
>

Thanks. That was sure not intuitive for me!

Wayne

"Brendan Reynolds" 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" wrote in message
> news:eyUV9mQmGHA.3600@TK2MSFTNGP02.phx.gbl...
>> Using Access 2003 I am trying to create a text field that uses Lookup
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12060
>> 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".
>>
>
>


Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12060

Thanks. That helps.

Wayne

"Wolfgang Kais" 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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12060
>
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12060
> 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
>

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


"Kernow Girl" 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:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12060
>
>> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12060
>> 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".
>>
>>
>>

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12060
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12060
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".
>
>
>

Thanks.
Sounds like good advice.

Wayne

"Kernow Girl" 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12060
> it's
> only a couple of items I've found that it so much simpler that a static
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12060
> 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".
>>
>>
>>