"谷歌"风格搜索功能 [英] "Google" style search function

问题描述

我被要求创建一个谷歌我的SQL Server 2000 db使用和访问2003（.adp）前端表单的样式搜索功能。我希望能够在一个文本框中输入一些东西，并在弹出窗体中显示来自不同表格（记录中出现该字符串）的所有记录，用户可以从中选择要转到的其中一个记录（即他们将双击记录，它将在该记录中打开该表的正确表格。


有什么建议吗？这甚至可以访问吗？

I have been asked to create a "google" style search functon for my SQL server 2000 db using and access 2003 (.adp) front end form. I would like to be able to enter something into a text box and have all the records from different tables (where that string occurs in the record) shown in a popup form, from which the user can select one of the records to go to (i.e. they will double click on the record and it will open the proper form for that table at that record).

Any suggestions? Is this even possible in access?

推荐答案

我会说这是可能的，但并不容易。你对VBA有多舒服？这里有一些关于我如何开始的快速伪代码。

I''d say it''s possible, but not exactly easy. How comfortable are you with VBA? Here''s some quick pseudocode for how I''d start.

展开 | 选择 | Wrap | 行号

对不起，您可能需要使用使用LIKE而不是*的％运算符。

Sorry, you may have to use the % operator with LIKE instead of *.

我想我明白了。循环遍历每个表中的每个字段并将任何匹配的记录添加到记录集中？

我虽然关于此但不知道如何连接不匹配的不同表中的记录集字段。


还有什么提示吗？ ：o）我对VBA有很多经验，但我不是一个全面的专家！

I think I get the idea. Cycle through each field in each table and add any matching records to a recordset?

I though about this but didn''t know how to concatenate a recordset from different tables with non-matching fields.

Any more hints? :o) I have quite a lot of experience with VBA but am not a full-on expert!

这篇关于"谷歌"风格搜索功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！