A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Allowing both multiple values and list edits in Lookup field



 
 
Thread Tools Display Modes
  #1  
Old February 12th, 2010, 01:56 AM posted to microsoft.public.access.tablesdbdesign
Jess
external usenet poster
 
Posts: 135
Default Allowing both multiple values and list edits in Lookup field

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.
  #2  
Old February 12th, 2010, 07:37 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Allowing both multiple values and list edits in Lookup field

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" wrote in message
...
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.



  #3  
Old February 12th, 2010, 08:51 PM posted to microsoft.public.access.tablesdbdesign
Jess
external usenet poster
 
Posts: 135
Default Allowing both multiple values and list edits in Lookup field

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" wrote in message
...
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.



.

  #4  
Old February 13th, 2010, 12:27 AM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Allowing both multiple values and list edits in Lookup field

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" wrote in message
...
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" wrote in message
...
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.



.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.