SearchBox NoComboBox NoWizardSearchCmd [英] SearchBox NoComboBox NoWizardSearchCmd

问题描述

我正在尝试在我的表单上放置一个文本框，我可以输入我正在搜索的内容（我希望能够在搜索框中输入可能位于表单上任何字段的信息;我希望这个文本框能够搜索表单上的任何字段而不使用组合框，我必须选择字段，然后输入我要搜索的内容，我不想使用向导创建一个搜索命令基本上是CTRL + F）。我特定于我想要的东西。所以，如果你可以提供帮助那就太棒了......以下是我的字段名称，如果我可以获取代码并将其复制并粘贴到Microsoft Visual Basic中，那将非常有用。请注意，我正在使用Access 2003，如果这会产生影响。


调用搜索命令：cmdSearch

调用未绑定的搜索字段： txtSearchString


字段名称如下：

PhysicianName

PrimaryHospital

地址1

地址2

地址3

CityStateZipCode


请帮助，只有你能做我所问的我已经知道如何进行组合框搜索和向导搜索，也不喜欢。此外，如果我看到我有回应，我会感到兴奋，然后在意识到2年试图解决这个问题时会感到沮丧:(


如果你能提供帮助，谢谢你们太多了我用这个我甚至不知道怎么解释我能​​做到这一点真棒！!!! div class =h2_lin>解决方案

看起来像这样我觉得：

展开 | 选择 | Wrap | 行号

我的表名是USPhysicianDirectory，我想要搜索按钮的表单名称是USPhysicianDirectoryFM ...我会在哪里复制并粘贴你给我的这些信息？我会转到搜索按钮并选择On Click：[Event Procedure]然后将其复制到MVB中，还是转到未绑定的文本框？单击：[Event Procedure]然后将其复制到MVB中？对不起，我真的不明白...我还需要更改代码中的任何内容以适合我的表单，还是已经设置好并准备复制了？非常感谢你帮助我!!!

意图是每次在文本框tb_Search中释放密钥时代码都会运行。如果您阅读第一行，也会在代码中显示。

I am trying to put a text box on my form where I can just type in what I am searching for (I want to be able to type in information in the search box that may be on any field on the form; I want this text box to have the ability to search any field on the form without me using a combo box where I have to select the field then type in what I am searching for and I don''t want to use the Wizard to create a search command that is basically CTRL+F). I am specific to what I want. So if you could help that would be awesome...Here are my field names it would be so helpful if I could just get the code and copy and paste it into Microsoft Visual Basic. Mind you I am working with Access 2003 if that makes a difference.


Search Command is called: cmdSearch
Unbound Search Field is called: txtSearchString

Field Names are as follows:
PhysicianName
PrimaryHospital
Address1
Address2
Address3
CityStateZipCode

Please help only if you can do what I am asking I already know how to do the combo box search and wizard search and don''t like either. Plus if I see I have a response I will get excited and then be bummed when realizing that 2 years of trying to figure this out continues:(

Thank you soooooooo much if you can help me with this I wouldn''t even know how to explain how awesome it is that I could do this!!!

解决方案

It would look something like this I guess:

Expand|Select|Wrap|Line Numbers

The name of my table is USPhysicianDirectory and the name of the form that I want the search button on is USPhysicianDirectoryFM...where would I copy and paste this information you gave me? Would I go to the search button and select On Click:[Event Procedure] and then copy this in the MVB or would I go to the unbound text boxPOn Click:[Event Procedure] and then copy this in the MVB? Sorry don''t really understand...also do I need to change anything in the code to fit my form or is it all set and ready to be copied? Thank you so much for helping me!!!

The intent is that the code runs each time a key is released in the textbox tb_Search. This is also shown in the code, if you read the first line.

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