如何在字段中允许重复值 [英] How do I Allow Duplicate Values in a Field
问题描述
你好
我的组合框出了问题。我现在正在使用ms access 2007.It是当你在我的组合框中选择列表时有一些值我的组合框上的列表有一些金额，每次你在列表上选择的金额都在另一个字段上。我认为它是因为我把列表的价值放在了很多重复。如何在字段上允许重复值。谢谢
Hello
I got a problem on my combo box.I am now using ms access 2007.It is that when u select the list on my combo box there is some value that selected and the others are not.The list on my combo box have some amount that every time u select on the list there is amount that goes on the other field.I think its because the amount which i put on the value of the list have lots of duplicate. How can i allow duplicates value on a field.Thanks
推荐答案
Ashlot：
如何在字段上允许重复值
Ashlot:
How can i allow duplicates value on a field
问题的其余部分几乎没有任何意义，如果不是这样的话最后的位将被删除。然而，这个小部分是有道理的，所以我可以回答它。
当在表的设计模式下，导航到相关字段并向下看一个名为
The rest of the question makes little or no sense and had it not been for this bit at the end would have been deleted. However, this small part makes sense so I can answer it.
When in Design mode of a table, navigate to the relevant field and look down the properties for one called "Indexed". If this is set to No then duplicates will be allowed by there will be no index. Otherwise, if an index is also required, then choose Yes (No duplicates).
你好......
感谢您的回复。但我已经尝试了那些东西是（没有重复）和否但仍然没有工作。
这是前：
Tablename - " Combo_value" ;
字段名称 - "属性"和金额
" Properties"字段是组合框，每次单击组合中的列表时，金额直接转到金额。 $。
房产金额
平1 10,000
平2 7,000
单位3万
单位4 7,000
单位5 5,000
单位6 5,000
单位7 10,000
持平8 5,000
等等..
部分属性选择了值，但是其他具有相同值的值无法选择。请你帮我解决这个问题。我是这个程序的新手。谢谢
Hi Neo...
Thanks for responding.But i already tried those things Yes(No Duplicates)and No but still not working.
this is the ex:
Tablename - "Combo_value"
Fieldname - "Properties" and "Amount"
"Properties" field is the combo box and the amount every time it clicks the list in the combo goes directly to "Amount" field.
Properties Amount
Flat 1 10,000
Flat 2 7,000
Flat 3 10,000
Flat 4 7,000
Flat 5 5,000
Flat 6 5,000
Flat 7 10,000
Flat 8 5,000
and so on..
Some of the "Properties" value were selected but the others which have the same value cannot be selected..Can you pls help me about this.I am just new in this program..Thanks
Ashlot：
" Properties"字段是组合框，每次单击组合中的列表时，金额直接转到金额。领域。
Ashlot:
"Properties" field is the combo box and the amount every time it clicks the list in the combo goes directly to "Amount" field.
我希望我能提供帮助。不幸的是，你说什么以及你怎么说它实际上没什么意义我很不清楚你在说什么。以上面的引用行为例。 "属性"字段是组合框毫无意义。它有一个主语，一个动词和一个对象，但这是一个不可能的陈述。这没有道理。 每次点击组合中的列表时，金额直接转到金额。这意味着金额在某种程度上正在做一些点击。假设操作员正在进行点击的简单假设，它表示金额直接转到金额。应该告诉我什么，我不知道。这是一个很好的例子，但其余部分遵循类似的路线。所提供的一些信息是明智的 - 不幸的是，即使提出一个相对简单的问题，与之相关的解释也是不充分的。
试着理解你有责任用句子来写合理。我来这里是为了提供技术帮助 - 而不是为了解决这个问题而将措辞不好的问题转化为意义。前者我很乐意这样做。后者激烈地激怒了我。也许是因为我擅长前者，虽然我可以非常清楚地表达自己，但是当他们在没有考虑读者的情况下写下它时，我猜测人们试图说些什么是没用的。
现在，就问题而言，我给出的答案是正确的（这不是我的猜测。我绝对知道这一点。这不是一件难事）。如果这与您打算回答的问题不符，那么我只能建议您将来正确提出问题。
I wish I could help. Unfortunately, what you say and how you say it makes so little actual sense I have very little idea what you''re saying. Take the quoted line above for instance. "Properties" field is the combo box makes no sense. It has a subject, a verb and an object, yet it''s an impossible statement. It makes no sense. the amount every time it clicks the list in the combo goes directly to "Amount". This implies somehow the amount is doing some clicking. Assuming the easy assumption that the operator is doing the clicking, it says the amount goes directly to "Amount". What that is supposed to be telling me I have no idea. This was a good example line, but the rest follows on similar lines. Some of the information provided is sensible - unfortunately the explanation that goes with it is inadequate even to ask a relatively simple question.
Try to understand that it is your responsibility to write in sentences that make sense. I am here to give technical help - not to translate poorly worded questions into sense for you just to get to the question. The former I am happy to do. The latter irritates me intensely. Maybe because I''m good at the former and, though I can express myself very clearly, I''m useless at guessing what people are trying to say when they write it without any consideration for the reader.
Now, as far as the question asked is concerned, the answer I gave is correct (This isn''t guesswork on my part. I know this absolutely. It''s not a hard one). If that doesn''t match the question you intended to be answered, then I can only suggest you ask the question properly in future.
这篇关于如何在字段中允许重复值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
