如何使用组合框搜索记录/字段中的特定关键字 [英] How to search for a specific keyword within a record/ field using a combobox

问题描述

我想使用一个组合框，当我添加一个特定的单词时，它会搜索那个单词。在该表的特定领域的每个记录中。

即

1.扑热息痛500mg片剂

2. Ciprobay 500mg片剂

3. Amoxil 250mg片剂

（在npitems中）字段中


如果我在组合框中添加500mg（在...中搜索npitemstxt field，它应该过滤并显示no 1 + 2项并排除no 3，因为它必须具有500mg。在标题中，添加到组合框中


它不必具有Matchcase

查询名称：NPItemsQ

这是我走了多远


i试过这个 -

展开 | 选择 | Wrap | 行号

解决方案

假设您的表单上有一个名为[cboNPItems]的控件，那么：

展开 | 选择 | Wrap | 行号

您好N

无法使用它。我在下面提供了该特定问题的副本。


它没有选择性地允许您搜索记录的1个组成部分

即漂白5L然后我想要添加5L，并且在完整字段中包含5L的每个项目必须以组合框形式显示

thx以获得帮助

thx

我现在还添加了一个未绑定的搜索框

未绑定的搜索框中的代码运行良好但不会根据需要过滤请求的数据

展开 | 选择 | Wrap | 行号

I would like to use a combobox and when i add a specific word, it will search for that "word" throughout every record in that specific field of the table.
ie
1. Paracetamol 500mg tablets
2. Ciprobay 500mg tablets
3. Amoxil 250mg tablets
(in npitems) field in table

If i add 500mg to the combobox (to search within the "npitems" txt field), it should filter and display items no 1 + 2 and exclude no 3, as it has to have "500mg" in the title, added to the combobox

It does not have to have "Matchcase"
Query name: NPItemsQ
This is how far i got


i have tried this -

Expand|Select|Wrap|Line Numbers

解决方案

Assuming you have a control on your form called [cboNPItems] then :

Expand|Select|Wrap|Line Numbers

Hi N
Cant get it to work. I include a copy of that specific issue below.

It does not selectively allow you to search for 1 component of a record
ie bleach 5L then i want to add 5L, and every item that contains 5L in the complete field must show up in combobox pls
thx for assistance
thx

I have also added an unbound search box now
Code in unbound searchbox that work well but does not filter requested data as required

Expand|Select|Wrap|Line Numbers

这篇关于如何使用组合框搜索记录/字段中的特定关键字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！