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?
14  3796 
"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.
Qty Number (Double)
CostEach Currency
"Trevor Best" <bouncer@localhost> wrote in message
news:ra********************************@4ax.com... 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.
Does it make any difference whether you create the MDE on your PC or the
client's PC?
TC
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u... Qty Number (Double)
CostEach Currency
"Trevor Best" <bouncer@localhost> wrote in message
news:ra********************************@4ax.com... 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.
Interesting question, TC. I did not try that, but have had experience where
creating the MDE on the client machine made a difference to stability in
A2000 SP1.
However, I'm starting to suspect the network at the client site.
We are now seeing another issue where a combo fails to display all the
records in the list. Changing the option under Tools | Options | Edit/Find |
"Don't display lists with more than" from 1000 to 10000 temporarily solved
the problem, but after a restart the problem is back. There are only 41
items in the combo's RowSource.
"TC" <a@b.c.d> wrote in message news:1070333116.340442@teuthos... Does it make any difference whether you create the MDE on your PC or the
client's PC?
TC
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u... Qty Number (Double)
CostEach Currency
"Trevor Best" <bouncer@localhost> wrote in message
news:ra********************************@4ax.com... 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?
Seems very strange. The reason I asked about where the MDE was created, is
that (as you know) the references are frozen in the MDE. So if they are
different on the client PC to your PC, that could cause some problems. This
would come to light if creating the MDE on the client PC caused the problem
to go away.
Cheers,
TC
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u... Interesting question, TC. I did not try that, but have had experience
where creating the MDE on the client machine made a difference to stability in
A2000 SP1.
However, I'm starting to suspect the network at the client site.
We are now seeing another issue where a combo fails to display all the
records in the list. Changing the option under Tools | Options | Edit/Find
| "Don't display lists with more than" from 1000 to 10000 temporarily solved
the problem, but after a restart the problem is back. There are only 41
items in the combo's RowSource.
"TC" <a@b.c.d> wrote in message news:1070333116.340442@teuthos... Does it make any difference whether you create the MDE on your PC or the
client's PC?
TC
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u... Qty Number (Double)
CostEach Currency
"Trevor Best" <bouncer@localhost> wrote in message
news:ra********************************@4ax.com...
> 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?
Is it worth looking at RAM, swap file, HD fragmentation, No. of apps open,
etc.Even your test with an .mdb could have been influenced by such
considerations.
Clive
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u... Interesting question, TC. I did not try that, but have had experience
where creating the MDE on the client machine made a difference to stability in
A2000 SP1.
However, I'm starting to suspect the network at the client site.
We are now seeing another issue where a combo fails to display all the
records in the list. Changing the option under Tools | Options | Edit/Find
| "Don't display lists with more than" from 1000 to 10000 temporarily solved
the problem, but after a restart the problem is back. There are only 41
items in the combo's RowSource.
On Tue, 2 Dec 2003 09:47:20 +0800 in comp.databases.ms-access, "Allen
Browne" <Al*********@SeeSig.Invalid> wrote: Qty Number (Double)
CostEach Currency
Still can't reproduce that error, mind you the machine I used was
clean (just ran Seti@home) until I installed Office onto it. As a
general rule, we usualy insist on clients getting themselves up to the
same SP level as our development machines, that way we can have a
level playing field as far as we can go and rule out any
inconsistencies that may be caused by different levels of patching.
Thinking of Clive's comments, I had a zip file that was corrupt every
time I downloaded it. In the end I renamed the existing download
instead of overwriting it and the next download was fine. Turned out
to be a bad sector on the disk.
Does the error still occur if you put your calculation into the form's
control rather than the query? Moreover does the error stil occur if
you run the query on it's own?
--
A)bort, R)etry, I)nfluence with large hammer.
Thanks very much for testing, Trevor. It's very encouraging to know that you
could not repro the error either.
What we are planning at this stage is to install a runtime tomorrow. If I
understand correctly, this guarantees there are no differences between their
service packs/dlls and mine.
If the problem still exists and the client's drive is not corrupt, the only
remaining differences are network ones. (Their server is NT4SP6a, running on
a fibre network - both different from my dev environment.)
--
"Trevor Best" <bouncer@localhost> wrote in message
news:83********************************@4ax.com... On Tue, 2 Dec 2003 09:47:20 +0800 in comp.databases.ms-access, "Allen
Browne" <Al*********@SeeSig.Invalid> wrote:
Qty Number (Double)
CostEach Currency
Still can't reproduce that error, mind you the machine I used was
clean (just ran Seti@home) until I installed Office onto it. As a
general rule, we usualy insist on clients getting themselves up to the
same SP level as our development machines, that way we can have a
level playing field as far as we can go and rule out any
inconsistencies that may be caused by different levels of patching.
Thinking of Clive's comments, I had a zip file that was corrupt every
time I downloaded it. In the end I renamed the existing download
instead of overwriting it and the next download was fine. Turned out
to be a bad sector on the disk.
Does the error still occur if you put your calculation into the form's
control rather than the query? Moreover does the error stil occur if
you run the query on it's own?
On Tue, 2 Dec 2003 17:26:33 +0800 in comp.databases.ms-access, "Allen
Browne" <Al*********@SeeSig.Invalid> wrote: Thanks very much for testing, Trevor. It's very encouraging to know that you
could not repro the error either.
What we are planning at this stage is to install a runtime tomorrow. If I
understand correctly, this guarantees there are no differences between their
service packs/dlls and mine.
Just a thought, will that not upgrade the DLLs used by their own
installation of Access up to your SP level without upgrading their
msaccess.exe thereby introducing an unknown environment for them?
If the problem still exists and the client's drive is not corrupt, the only
remaining differences are network ones. (Their server is NT4SP6a, running on
a fibre network - both different from my dev environment.)
What about Jet service packs (as installed by WindowsUpdate nowadays).
--
A)bort, R)etry, I)nfluence with large hammer.
Have you tried creating the MDE on the client's PC yet? I still think it
would be significant if the MDE created on your PC did not work on the
client's PC, but the MDE created on his one, did.
TC
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u... Thanks very much for testing, Trevor. It's very encouraging to know that
you could not repro the error either.
What we are planning at this stage is to install a runtime tomorrow. If I
understand correctly, this guarantees there are no differences between
their service packs/dlls and mine.
If the problem still exists and the client's drive is not corrupt, the
only remaining differences are network ones. (Their server is NT4SP6a, running
on a fibre network - both different from my dev environment.)
--
"Trevor Best" <bouncer@localhost> wrote in message
news:83********************************@4ax.com...
On Tue, 2 Dec 2003 09:47:20 +0800 in comp.databases.ms-access, "Allen
Browne" <Al*********@SeeSig.Invalid> wrote:
Qty Number (Double)
CostEach Currency
Still can't reproduce that error, mind you the machine I used was
clean (just ran Seti@home) until I installed Office onto it. As a
general rule, we usualy insist on clients getting themselves up to the
same SP level as our development machines, that way we can have a
level playing field as far as we can go and rule out any
inconsistencies that may be caused by different levels of patching.
Thinking of Clive's comments, I had a zip file that was corrupt every
time I downloaded it. In the end I renamed the existing download
instead of overwriting it and the next download was fine. Turned out
to be a bad sector on the disk.
Does the error still occur if you put your calculation into the form's
control rather than the query? Moreover does the error stil occur if
you run the query on it's own?
Thanks for the feedback and suggestions on this.
We are writing this experience down to a network issue.
Moving the data file onto the local hard disk solved both issues (#Error is
calculated fields, and items absent from drop-down list).
Further, sharing the data mdb locally on one of the Windows 2000 machines
caused the software to run correctly on all 3 computers (presumably plugged
into the same hub). Their main LAN is quite extensive with the server in
another building (and parking lots in between), so the problem would appear
to be unrelated to Access itself.
Thanks again for your help. This n.g. is a great resource.
"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? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Morten Gulbrandsen |
last post by:
mysql> USE company;
Database changed
mysql>
mysql> DROP TABLE IF EXISTS EMPLOYEE;
--------------
DROP TABLE IF EXISTS EMPLOYEE
--------------
Query OK, 0 rows affected (0.00 sec)
|
by: Bercin Ates via SQLMonster.com |
last post by:
I?m getting an error when I execute a stored procedure which is try to insert a row to a table.
The error is:
Server: Msg 1934, Level 16, State 1, Procedure SRV_SP_IS_EMRI_SATIRI_EKLE, Line 32...
|
by: Jack |
last post by:
Hi,
I have posted this problem before. Apprently, the suggestion took care of
the problem. However, still I am getting the above error message.
I am using a session variable to transfer a value...
|
by: Kathy Houtami |
last post by:
Hi there
I've been encountered with weird compile error using Access 97.
The error message is "Member or data member is not found" and it
highlighted a line of code that has not be changed and...
|
by: Yuki |
last post by:
Thanks for taking the time to look at my problem. I keep getting a
#Name error from a calculated field on a form. It is a text box field
unbound. The calculation is very very simple yet I still...
|
by: Norbert Lieckfeldt |
last post by:
MS Access 2002 here. I am just trying to set up a simple database for a
friend who's an optician. Basically, all clients with address details, date
of last eyetest and a drop-down combo box to...
|
by: Henrik |
last post by:
The problem is (using MS Access 2003) I am unable to retrieve long
strings (255 chars) from calculated fields through a recordset.
The data takes the trip in three phases:
1. A custom public...
|
by: jcf378 |
last post by:
hi all.
I have a form which contains a calculated control ("days") that outputs the # of days between two dates (DateDiff command between the fields and ).
However, when I click "Filter by...
|
by: bhrosey via AccessMonster.com |
last post by:
I have a calculated field on a form that has this formula:
=IIf(<>0,/(-),/)
The problem is when the if statement is false, it's partly because Field2 is
zero, so when it tries to devide...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |
