同步两种形式？ [英] Synchronizing two forms?

问题描述

大家好，


我有两种形式，已经同步，但是，每当我查看下一组数据时，两次查询都会再次运行。这会使我的数据库变慢到无法响应的程度。有没有办法加速这些形式的反复运行？

Hello all,

I have two forms, which are already synchronized, however, everytime I page to the next set of data both queries run again. This slows down my database to a point of unreponsiveness. Is there a way to speed up these forms from running over and over?

推荐答案

Hello all，


我有两种表格已经同步，但是，每当我查看下一组数据时，两次查询都会再次运行。这会使我的数据库变慢到无法响应的程度。有没有办法加快这些形式的反复运行？

Hello all,

I have two forms, which are already synchronized, however, everytime I page to the next set of data both queries run again. This slows down my database to a point of unreponsiveness. Is there a way to speed up these forms from running over and over?

eskelies。


你绝对应该提供更多信息。

• 什么是同步"是什么意思？
• 运行什么查询？
• 您认为可以帮助其他人了解您的情况的任何其他信息。




鱼，


对不起......让我试着更好地解释一下。我在下面有两个查询，我知道这些查询很大：


我正在对两个查询中表示的数据进行分析。当我在它们周围构建表单时，我不使用所有数据，而是使用在相应表单中填充的某些字段。例如，我在查询1中使用账号，先前贡献收益率，估计收益率等。对于查询2也是如此，但是，我的目标是将表单1（即查询1）与表单2（查询）同步2），这样当我选择某个帐号时，表格1和表格2中的信息显示在新帐号下的帐号中。形成。我开始这样做是通过一个未绑定的表格（即表格3）并带来表格1.然后从那里我将表格1的帐号与表格2的帐号相关联。在这种情况下，它可以工作，但是，每次我尝试提出一个新的帐号时，似乎Access请求查询1和查询2再次运行。我希望有一种方法可以让它更顺畅，更快速地运行。


我希望这里有足够的信息来帮助我。谢谢。


QUERY 1：


Fish,

Sorry...Let me try and explain better. I have two queries below, which I know are large:

I am doing analysis on the data that is represented in the two queries. I do not use all of the data when I build forms around them, instead I use certain fields which populate within the appropriate form. For instance, I use Account Number, prior contribution yield, est contribution yield, etc. in query 1. The same thing goes for query 2, however, my goal is to synchronize form 1 (ie. query 1) with Form 2 (query 2), so that when I select a certain account number the information in form 1 and form 2 shows up under account number in the "new" form. I started doing this by taking an unbound form (ie. Form 3) and bringing in Form 1. Then from there I linked form 1''s account number with form 2''s account number. In this instance it works, however, everytime I try to bring up a new account number it seems as if Access is requesting query 1 and query 2 to run again. I was hoping there is a way to get this to run smoother and faster.

I hope there is enough information here to help me. Thank you.

QUERY 1:


展开 | 选择 | Wrap | 行号




Ok。


相当令人印象深刻。

你能否发布更多关于如何填充Form3的细节。

它是否与任何记录集绑定（或对他们两个人来说）？

这是什么意思引入表格1？

Form3应该是只读的吗？

如果使用任何代码，请发布。


问候，

鱼。


PS您可能还会发现有关如何优化查询和记录集的文章




这篇关于同步两种形式？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！