查询问题 [英] Query problems

问题描述

我有一个完美的查询但我希望遍历查询并从查询中选择特定部分，例如ID，地址，然后可以发送它以执行另一个功能。


我当前的解决方案是用所需的信息填充列表框但是我不知道如何提取值，我已经尝试了使用组合框的解决方案，但是在遍历所有项目以选择它们时，项目仍未被选中，因此Comobox .text有一个空值。


任何帮助都会受到赞赏。

解决方案

我们需要更多细节您提供的内容，例如：

1. 查询所基于的表。
2. 构成查询的字段名称及其数据类型。
3. 您要提取的特定字段。
4. 您希望将这些字段值提取到哪里？列表框，组合框等
5. 接受这些值的对象的名称是什么？
6. etc ...

1。查询基于的表。

2.构成查询的字段名称及其数据类型。

3.要提取的特定字段。

4.您希望将这些字段值提取到哪里？列表框，组合框等

5.接受这些值的对象名称是什么？

6.等等......



查询所基于的表是通用表（tbl1），所有字段名称都基于客户端列表，构成查询的字段是CandidateName，phone，email。所有这些都是文本数据类型。

我希望将查询中的电话数据提取到列表框/组合框中，然后放入备忘录框中


自从listbox / combobox已经包含了我想提取的数据项我想知道如何从列表框中提取信息并放入备忘录框，或者使用记录集并迭代查询返回的集合会更简单？

1.查询基于的表。

2.字段名称及其数据类型包含查询。

3.您想要提取的特定字段。

4.您希望将这些字段值提取到哪里？列表框，组合框等

5.接受这些值的对象名称是什么？

6.等等......



查询所基于的表是通用表（tbl1），所有字段名称都基于客户端列表，构成查询的字段是CandidateName，phone，email。所有这些都是文本数据类型。

我希望将查询中的电话数据提取到列表框/组合框中，然后放入备忘录框中


自从listbox / combobox已经包含了我想提取的数据项我想知道如何从列表框中提取信息并放入备忘录框，或者使用记录集并迭代查询返回的集合会更简单？

由于列表框已包含我想提取的数据项，我想知道如何从列表框中提取信息并放入备忘录box

1. Memo Box究竟是什么意思？
2. 以什么格式祝电话提取列表/组合框中的数字？例如
   

   展开 | 选择 | Wrap | 行号

I have a query which works perfectly but I wish to iterate through the query and select specific portions from the query such as ID, address which can then be sent to perform another function.

My current solution is to fill a listbox with the required information however I have no idea how to extract the values, I have tried a solution with combobox however, upon iterating through all the items to select them the items remain unselected and thus Comobox.text has a null value.

Any help would be appreciated.

解决方案

We will need much more detail that that which you have provided, such as:

1. Table the Query is based on.
2. Field Names and their Data Types that comprise the Query.
3. Specific Fields you wish to extract.
4. Where do you wish to extract these Field values to? List Box, Combo Box, etc.
5. What is the Name of the Object that will accept these values?
6. etc...

1. Table the Query is based on.
2. Field Names and their Data Types that comprise the Query.
3. Specific Fields you wish to extract.
4. Where do you wish to extract these Field values to? List Box, Combo Box, etc.
5. What is the Name of the Object that will accept these values?
6. etc...


The table the query is based on is a generic table (tbl1) all field names are based on client listing, the ones that the comprise the query are CandidateName, phone, email. all of which are text data type.
I wish to extract the phone data from the query into a listbox/combobox then into a memo box

Since the listbox/combobox already contains the data items i wish to extract I would like to know how to extract the information from the listbox and put into the memo box, or would it be simpler to use a recordset and iterate through the set returned by the query?

1. Table the Query is based on.
2. Field Names and their Data Types that comprise the Query.
3. Specific Fields you wish to extract.
4. Where do you wish to extract these Field values to? List Box, Combo Box, etc.
5. What is the Name of the Object that will accept these values?
6. etc...


The table the query is based on is a generic table (tbl1) all field names are based on client listing, the ones that the comprise the query are CandidateName, phone, email. all of which are text data type.
I wish to extract the phone data from the query into a listbox/combobox then into a memo box

Since the listbox/combobox already contains the data items i wish to extract I would like to know how to extract the information from the listbox and put into the memo box, or would it be simpler to use a recordset and iterate through the set returned by the query?

Since the listbox already contains the data items i wish to extract I would like to know how to extract the information from the listbox and put into the memo box

1. What exactly do you mean by Memo Box?
2. In what format do the wish the Phone Numbers in the List/Combo Box extracted? e.g.
   

   Expand|Select|Wrap|Line Numbers

这篇关于查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！