So many folks find their way to Access from Excel. I generally advise them
that they are at a disadvantage when it comes to learning Access, for just
that reason <g>.
Good luck!
Regards
Jeff Boyce
Microsoft Access MVP
--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.
You can thank the FTC of the USA for making this disclaimer
possible/necessary.
"Jess" <(E-Mail Removed)> wrote in message
news:F3CE9194-1047-4232-8C20-(E-Mail Removed)...
>I have noticed a general dislike of using lookup in tables, but I hadn't
> really been clear on the distinction between tables and forms. I haven't
> even
> tried getting that technical with the form, so I will try that now! I'm a
> beginner in Access, so I'm not yet very familiar with it.
>
> Thank you for your clarification that using lookups in tables and in forms
> are two completely separate issues, and for pointing out that tables are
> NOT
> spreadsheets, as I have been treating them.
>
> Jess
>
> "Jeff Boyce" wrote:
>
>> Jess
>>
>> If you are saying that you are attempting to do this while working
>> directly
>> in the table, STOP NOW!
>>
>> The "lookup" data type in Access tables is held in general low regard if
>> you
>> scan through this newsgroup.
>>
>> Access tables are, for practical purposes, "buckets o' data". They may
>> look
>> like a spreadsheet, but they are not...
>>
>> Access forms are quite useful for displaying (add/edit/...) data. Using
>> a
>> combobox control in a form is the way to handle looking up.
>>
>> And if you are using a value list instead of a table to hold those "might
>> be
>> looked up" values, consider shifting over to a table (call it a lookup
>> table). That way, you aren't burying the list of valid values somewhere
>> deep inside a control, inside a form.
>>
>> Good luck!
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Access MVP
>>
>> --
>> Disclaimer: This author may have received products and services mentioned
>> in this post. Mention and/or description of a product or service herein
>> does not constitute endorsement thereof.
>>
>> Any code or pseudocode included in this post is offered "as is", with no
>> guarantee as to suitability.
>>
>> You can thank the FTC of the USA for making this disclaimer
>> possible/necessary.
>>
>> "Jess" <(E-Mail Removed)> wrote in message
>> news:9E1E5479-1A30-4B47-9EB5-(E-Mail Removed)...
>> > In Access 2007 I am trying to make a table column utilize a combo box
>> > that
>> > allows both multiple values and list edits. However, when I set it to
>> > allow
>> > both features, it doesn't let me make any edits to the list in the
>> > table;
>> > the
>> > multiple values aspect works just fine. When I don't allow multiple
>> > values, I
>> > can edit it to my heart's content.
>> >
>> > Anyone know a way around this problem? I know that I'm doing it right
>> > (all
>> > you have to do is select "Yes"!) but it's jut not allowing me to have
>> > both
>> > allowances as it should.
>>
>>
>> .
>>
|
Similar Threads
