嗨Paul


我的建议是使用内置的Documenter转到工具菜单 - 分析 - 文件管理员。


转到查询选项卡并选择全部。然后转到选项并勾选sql框。确保未勾选其他选项或将其设置为空。运行时，会生成每个查询的所有SQL代码的访问报告。您无法保存此文档，但您可以打印它或将其导出为rtf。


然后您可以搜索文本。


玛丽

Hi Paul

My advice is to use the built in Documenter Go to Tools Menu - Analyse - Documenter.

Go to the queries tab and select all. Then go to options and tick the sql box. Make sure the other options are not ticked or set to nothing. When run this produces an access report of all the SQL code for each query. You cannot save this document but you can print it or export it as a rtf for example.

You can then search the text.

Mary

嗨玛丽，


感谢您的提示。我忘记了记录员了。一次提取近千个查询将是一项重大操作，但我想这可能是搜索所有查询的唯一方法。我想我会让它在一夜之间运行。 :)


谢谢，

Paul

Hi Mary,

Thanks for the tip. I had forgotten about the documenter. It''s going to be a major operation to extract almost a thousand queries at once, but I guess this may be the only way to search them all. I think I''ll let it run overnight. :)

Thanks,
Paul

@prn


有一个vba代码解决方案，但我认为它会非常沉重。本质上，它应该是在查询定义中打开每个查询并在sql中搜索关键字，然后关闭该查询并循环到下一个查询。考虑到查询的数量，我无法想象它会是多么繁重。实际上我甚至试图考虑如何搜索sql，因为它不是我通常会做的事情。

@prn
There is a vba code solution but I think it would be very heavy. Essentially it would be a matter of opening every query in query definition and searching the sql for key words, then closing that query and looping to the next one. I can''t imagine it would be anything but onerous considering the number of queries. Actually I''m even trying to think how to search the sql as it''s not something I would normally do.