更新到2007后的关键字搜索问题 [英] Problem with Keyword search after updateing to 2007

问题描述

我的数据库页脚栏上有一个关键字搜索按钮，单击该按钮会打开一个弹出框，您可以在其中键入关键字。输入关键字后，将其放入查询中，将表单过滤到多个字段中的该关键字。问题是，自从我升级到2007年以后，它才第一次运行。如果您尝试再次使用它，它不会显示弹出框，只是为您键入的第一个工作重新过滤。解决这个问题的唯一方法是完全关闭和重启，这很烦人！我没有写这个代码，我不知道如何解决它，任何帮助将不胜感激！代码如下。


谢谢

I have a keyword search button on my databases footer bar which when clicked opens a pop-up box that you can type a key word into. When the keyword is entered it put it into a query that filters my form to that keyword in several fields. Problem is that since my upgrade to 2007, it only works the first time. If you try to use it again it does not display the pop-up box and just re-filters for the first work you typed. The only way around this is a full shut down and restarts which is getting annoying! I did not write this code and I am not sure how to fix it, any help would be greatly appreciated! Code is below.

Thanks

展开 | 选择 | 换行 | 行号

推荐答案

听起来您需要在继续新搜索之前清除搜索结果。请发布sql for qrykeyword，以及与stLinkCriteria构建相关的代码。

It sounds like you need to clear your search results before proceeding with a new search. Please post the sql for qrykeyword, and the code relating to the build of stLinkCriteria.

这是关键字查询的SQL：

Here is the SQL for the Keyword query:

展开 | 选择 | Wrap | 行号

@Redbeard


我不明白为什么。这里缺少引号。它应该是：

@Redbeard
I don''t understand why. The quotes are missing from this. It should read :

展开 | 选择 < span class =codeDivider> | Wrap | 行号

这篇关于更新到2007后的关键字搜索问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！