如何在MS Access中禁用自动计算 [英] How to disable Automatic Calculation in MS Access

问题描述

我有一个包含4个计算字段的查询，其中一个使用DSum计算运行总和

I have a query with 4 calculated fields , one of them calculate the running sum using DSum

运行此查询并转到最后一条记录时，需要花费一些时间(正常且可以)

When running this query and go to the last record it is taking some time (that is normal and OK)

但是问题是，每次我使用鼠标滚轮向上或向下滚动时，MS Access都会重新计算该字段，并且这种重新计算会花费很长时间，从而使该查询不可用

But the problem is that MS Access recalculate this field every time I scroll up or down using mouse wheel, and this recalculation taking a very long time that make this query unusable

我认为MS Access会执行此重新计算，因为它是多用户应用程序，因此我将其更改为排他"(文件">选项">客户端设置">高级">默认打开模式">排他")，但这无济于事

I think MS Access do this recalculation because it is multi user application so I change it to Exclusive (File > Options > Client Settings > Advanced > Default open mode > Exclusive) , but this not help

因此，我正在寻找类似Excel的功能来禁用自动计算并计算所需的内容以及何时需要使用VBA进行MS Access，或者至少防止每次我上下滚动时MS Access重新计算查询.

So Im looking for something like Excel to disable automatic calculation and calculate what you need and when you need using VBA for MS Access or at least prevent MS Access from recalculate the query every time I scroll up or down.

• 最多只能有一个用户同时使用我的数据库
• 该查询大约有40,000条记录

推荐答案

正如尼克所说，你做不到.

As Nick wrote, you can't.

要查看数据而无需重新计算，请将其放入报表中，或使用INSERT INTO或SELECT INTO操作查询将其保存到临时表中.如果您想对数据做进一步的计算，或者如果它是另一个查询的记录源，则后者特别有用.

To view the data without recalculation, put it into a report, or use a INSERT INTO or SELECT INTO action query to save it to a temporary table. The latter is especially useful, if you want to do further calculations on the data, or if it is the recordsource of another query.

这篇关于如何在MS Access中禁用自动计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！