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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|