MDE中计算字段中的#Error（不是MDB） [英] #Error in calculated field in MDE (not MDB)

问题描述

子表格基于包含计算字段的单表查询：

金额：回合（CCur（Nz（[数量] * [CostEach]，0）），2）


连续子表单在名为Amount的文本框中显示此字段。

当用户在子表单中输入新行时，所有行在此框中显示#Error。

只有在他们关闭表单或将主表单移动到

不同记录时才会发生这种情况。


更糟糕的是，它只发生在MDE中客户端的计算机。

相同的MDB文件正确显示计算结果。

客户端在Windows 2000上运行Access 2000 SP1。

甚至MDE在我的dev上正确显示。机器（WinXP上的A2000 SP3）。


子窗体上没有其他计算字段可能会干扰。

金额文本框没有默认值。它的格式是货币。


实际上有3个子表格从同一个表中选择（部分，
人工，费用），它们都展示了同样的问题。


拆分应用程序（在本地，在服务器上）。只有3个代码引用（Access，VBA，

DAO）。所有在场并正确注册。


什么可能导致它在MDE中错误地显示但在MDB中正确显示？

解决方案

" Allen Browne" <铝********* @ SeeSig.Invalid>在留言中写道

news：3f ********************** @ freenews.iinet.net.a u ...

子表单基于包含计算字段的单表查询：
金额：舍入（CCur（Nz（[数量] * [CostEach]，0）），2）

连续子窗体在名为Amount的文本框中显示此字段。
当用户在子窗体中输入新行时，所有行在此框中显示#Error。
这只会在关闭窗体之前发生，或将主窗体移动到不同的记录。

更糟糕的是，它只发生在MDE中客户端的机器上。
相同的MDB文件显示计算结果正确。
客户端在Windows 2000上运行Access 2000 SP1。
即使MDE在我的dev上正确显示。机器（WinXP上的A2000 SP3）。

子窗体上没有其他计算字段可能会干扰。
数量文本框没有默认值。它的格式是货币。

实际上有3个子表格从同一个表格中选择
（零件，人工，费用），它们都表现出相同的问题。
<拆分应用程序（本地，在服务器上）。只有3个代码引用（Access，
VBA，DAO）。所有在场并正确注册。

什么可能导致它在MDE中显示错误但在

MDB中正确显示？


如果在客户端站点上加载MDB，它是否有效？我怀疑服务包中的
差异是罪魁祸首而不是

这是一个MDE。

即使在客户的机器上，MDB也没有问题。


Trev @ Work <摇椅@本地>在消息中写道

新闻：3f *********************** @ news.easynet.co.uk。 ..

" Allen Browne" <铝********* @ SeeSig.Invalid>在消息中写道
新闻：3f ********************** @ freenews.iinet.net.a你...

子表单基于包含计算的
字段的单表查询：金额：舍入（CCur（Nz（[数量] * [CostEach]，0）），2）
连续子窗体在名为Amount的文本框中显示此字段。
当用户在子窗体中输入新行时，所有行在此框中显示#Error。
这只会在关闭窗体或移动之前发生不同记录的主要形式。

更糟糕的是，它只发生在MDE中客户端的机器上。
相同的MDB文件正确显示计算结果。客户端在Windows 2000上运行Access 2000 SP1。
即使MDE在我的dev上正确显示。机器（WinXP上的A2000 SP3）。

子窗体上没有其他计算字段可能会干扰。
数量文本框没有默认值。它的格式是货币。

实际上有3个子表格从同一个表格中选择

（部分，

人工，费用），以及他们都表现出同样的问题。

拆分应用程序（本地，在服务器上）。只有3个代码引用（Access，

VBA，

DAO）。所有在场并正确注册。

什么可能导致它在MDE中显示错误但在

MDB中正确显示？

是否有效您在客户端站点上加载MDB？我怀疑服务包中的差异是罪魁祸首，而不是它是MDE的事实。

2003年12月1日星期一23:25:37 +0800 comp.databases.ms-access，Allen

Browne <铝********* @ SeeSig.Invalid>写道：

即使在客户端的机器上，MDB也没有问题。

我''我试过在O2K SP1机器上重新创建这个场景，但我的测试

工作正常。表中涉及哪些数据类型？


-

A）bort，R）etry，I）用大锤子影响。

Subform is based on a single-table query that contains a calculated field:
Amount: Round(CCur(Nz([Qty]*[CostEach],0)),2)

Continuous subform displays this field in a text box named Amount.
As user enters new rows into subform, all rows show #Error in this box.
This only happens until they close the form, or move the main form to a
different record.

Worse, it only happens on the client''s machine in the MDE.
The identical MDB file shows the calculation correctly.
Client is running Access 2000 SP1 on Windows 2000.
Even MDE shows correctly on my dev. machine (A2000 SP3 on WinXP).

No other calculated fields on the subform could interfere.
Amount text box has no Default Value. Its Format is Currency.

There are actually 3 of these subforms selecting from the same table (parts,
labor, expenses), and they all exhibit the same problem.

Split app (f.e. local, b.e. on server). Only 3 code references (Access, VBA,
DAO). All present and registered correctly.

What could cause this to display wrongly in an MDE but correctly in an MDB?

解决方案

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...

Subform is based on a single-table query that contains a calculated field:
Amount: Round(CCur(Nz([Qty]*[CostEach],0)),2)

Continuous subform displays this field in a text box named Amount.
As user enters new rows into subform, all rows show #Error in this box.
This only happens until they close the form, or move the main form to a
different record.

Worse, it only happens on the client''s machine in the MDE.
The identical MDB file shows the calculation correctly.
Client is running Access 2000 SP1 on Windows 2000.
Even MDE shows correctly on my dev. machine (A2000 SP3 on WinXP).

No other calculated fields on the subform could interfere.
Amount text box has no Default Value. Its Format is Currency.

There are actually 3 of these subforms selecting from the same table (parts, labor, expenses), and they all exhibit the same problem.

Split app (f.e. local, b.e. on server). Only 3 code references (Access, VBA, DAO). All present and registered correctly.

What could cause this to display wrongly in an MDE but correctly in an

MDB?

Does it work if you load an MDB on the client site? I''d suspect the
difference in service packs would be the culprit rather than the fact that
it''s an MDE.

The MDB does not have the problem, even on the client''s machine.

"Trev@Work" <bouncer@localhost> wrote in message
news:3f***********************@news.easynet.co.uk. ..

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...

Subform is based on a single-table query that contains a calculated field: Amount: Round(CCur(Nz([Qty]*[CostEach],0)),2)

Continuous subform displays this field in a text box named Amount.
As user enters new rows into subform, all rows show #Error in this box.
This only happens until they close the form, or move the main form to a
different record.

Worse, it only happens on the client''s machine in the MDE.
The identical MDB file shows the calculation correctly.
Client is running Access 2000 SP1 on Windows 2000.
Even MDE shows correctly on my dev. machine (A2000 SP3 on WinXP).

No other calculated fields on the subform could interfere.
Amount text box has no Default Value. Its Format is Currency.

There are actually 3 of these subforms selecting from the same table

(parts,

labor, expenses), and they all exhibit the same problem.

Split app (f.e. local, b.e. on server). Only 3 code references (Access,

VBA,

DAO). All present and registered correctly.

What could cause this to display wrongly in an MDE but correctly in an

MDB?

Does it work if you load an MDB on the client site? I''d suspect the
difference in service packs would be the culprit rather than the fact that
it''s an MDE.

On Mon, 1 Dec 2003 23:25:37 +0800 in comp.databases.ms-access, "Allen
Browne" <Al*********@SeeSig.Invalid> wrote:

The MDB does not have the problem, even on the client''s machine.

I''ve tried re-creating this scenario on a O2K SP1 machine but my test
worked ok. What data types are involved in the table?

--
A)bort, R)etry, I)nfluence with large hammer.

这篇关于MDE中计算字段中的#Error（不是MDB）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！