在VBA中弹出Query Builder [英] pop up Query Builder in VBA

问题描述

嗨


:)


i想知道是否可以在VBA中调用查询构建器然后存储SQL用户构建（临时）查询后会出现这种情况吗？


类似于查找表中字段的方式


thanx提前


ol

hi

:)

i was wondering if it''s possible to call the query builder in VBA and then store the SQL it comes up with after the user has built a (temporary) query?

kind of like how the lookup for a field in a table works

thanx in advance

ol

推荐答案

我不知道这是一种可能性，但它'这是一个很好的主意。

从保存的查询中获取SQL（QueryDef）很简单，但在代码运行时让查询构建器窗口打开是另一回事。

如果你对此感到高兴，请告诉我们。

I''m not aware of that as a possibility, but it''s a neat idea.
Getting the SQL out of a saved query (QueryDef) is easy enough, but getting the query builder window to open while code is running is another matter.
Let us know if you get any joy with this.

我不知道这是一种可能性，但它这是一个很好的主意。

从保存的查询（QueryDef）中获取SQL很容易，但在代码运行时让查询构建器窗口打开是另一回事。

如果有，请告诉我们你对此感到高兴。

I''m not aware of that as a possibility, but it''s a neat idea.
Getting the SQL out of a saved query (QueryDef) is easy enough, but getting the query builder window to open while code is running is another matter.
Let us know if you get any joy with this.

我实际上可以通过一行代码进入后门来实现这个概念，而不是尝试在Access Builder /向导中挂钩代码， 随你。从Access环境中的任何位置调用此函数似乎都有效，但它确实存在缺陷。只要有机会就给我你的意见，我很好奇。我在AutoKeys宏中从RunCode调用此函数，并为其指定SHIFT + F9的快捷键组合。

I actually may get this concept to work from coming in the back door with a single line of code as opposed to trying to hook the code in the Access Builder/Wizard, whatever. Calling this Function from anywhere within the Access Environment seems to work, but it does have its faults. Just give me your input whenever you get a chance, I''m curious. I call this Function from RunCode within a AutoKeys Macro, and assign it the Shortcut Key combination of SHIFT+F9.

展开 | 选择 | Wrap | 行号

现在当操作员想要编辑查询但是编码器不想失去焦点时会发生什么？

或者，什么可以触发代码重新进入并使用new执行{whatever}查询一旦被保存了？


BTW在QueryBuilder上找到整齐的位：）

Now what happens when the operator wants to edit the query but the coder doesn''t want to lose focus?
Alternatively, what can trigger the code to come back in and do {whatever} with the new query once it''s been saved?

BTW Neat find on the QueryBuilder bit :)

这篇关于在VBA中弹出Query Builder的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！