显示按网络搜索（例如Cisco）或MS Access Table中的所有项目 [英] Display Search by Network (ex. Cisco) or All Projects in the MS Access Table

问题描述

大家好，


下面是一个GOOD工作脚本，用于通过MOP ID搜索记录，例如1,2等等...（记录在数据库）或网络，例如当您键入Cisco时。


我想做的是有问题的是网络搜索或数据库上的所有MOP ID（显示所有记录）。让我们说如果人们输入ALL，它将显示数据库中的所有MOP ID（记录）。谢谢你的帮助。

Hi All,

Below is a GOOD working script that I use to search for the record either by the MOP ID for example 1, 2, etc... (record on the database) or by Network for example when you type Cisco.

What I would like to do and is having problem is to either Search by Network or All MOP IDs on the database (show all records). Let''s say if folks type in ALL, it will show all of the MOP IDs (Records) in the database. Thanks advance for your help.

展开 | 选择 | Wrap | 行号

推荐答案

Hello hotflash，


给这个试一试：

Hello hotflash,

Give this a try:

展开 | 选择 | Wrap | < span class =codeLinkonclick =LineNumbers（this）;>行号

您好Crocrew，


它有效精细。感谢您的帮助。

Hi Crocrew,

It works fine. Thanks for your help.

您好CroCrew，


我还有一个问题，看看您是否可以帮我扩展搜索功能。下面是我用于按ProjectID，所有打开的项目和工程师名称搜索的搜索脚本。在MS Access表中，还有一个名为RequestorsName的字段。我如何修改这个嵌套的IF语句，使其也搜索例如Croor的RequestorName。我试过了，但没有运气。


感谢您的帮助。

Hi CroCrew,

I have another question to see if you can help me to expand the search function here. Below is the search script that I used to search by ProjectID, ALL OPENED PROJECTS, and by Engineer Name. In the MS Access table, there is a field called RequestorsName as well. How can I modified this nested IF statement to make it also search for RequestorName for exampe CroCrew. I have tried around but does not have any luck.

Thanks for your help.

展开 | 选择 | 换行 | 行号

这篇关于显示按网络搜索（例如Cisco）或MS Access Table中的所有项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！