Calculating... forever

[PaulHollingshead via AccessMonster.com]

This is more of a annoyance than anything else.

I have an access 2000 front end program that I develop in Access 2003 (before
compiling into MDE on an Access 2000 virtual machine). This has neven been a
problem.

Today I notice that a form keeps "Calculating..." at the bottom. In all other
respects the form operates normally. Nothing is slow / waiting for anything.

So I can't look for any help in any search engines (looking for "Calculating..
..") because the full stops are always stripped out and I get swamped with
tons of results from people wanting to add up stuff. MS's own web sites also
suffer from the same problem.

I've looked at the few posts I can find about it on here. I'll answer a few
questions before they are asked:

- All drop down combo boxes have populated themselves okay.
- No I'm not using any conditional formatting on any controls.

The form has tabs on it and one tab has a subform. There are many combos but
they seem okay. It does have a timer event but that only runs a procedure a
fraction of a second after the form has loaded - and only runs once.

The "of how many" bit at the bottom of the form does not appear at all - but
if you jump to the last record it appears immediately (no delay).

As this doesn't impare the operation of the form it's just something that is
annoying me and I'm wondering if it's due to one of the many updates /
service packs received from MS?

The development of the form in Access 2003 and compiling in 2000 is a bit non-
standard but that's just how this particular program has been developed in
the past and it's never caused any problems before. At the moment I'm seeing
this behaviour in the mdb being worked on in Access 2003 - I haven't checked
it's behaviour in Access 2000 yet.

Paul

 

[PaulHollingshead via AccessMonster.com]

I've tested it in Access 2000 and it's okay. It only occurs in Access 2003
SP3.

Paul

 

[Stuart McCall]

This is more of a annoyance than anything else.

I have an access 2000 front end program that I develop in Access 2003
(before
compiling into MDE on an Access 2000 virtual machine). This has neven been
a
problem.

Today I notice that a form keeps "Calculating..." at the bottom. In all
other
respects the form operates normally. Nothing is slow / waiting for
anything.

So I can't look for any help in any search engines (looking for
"Calculating..
") because the full stops are always stripped out and I get swamped with
tons of results from people wanting to add up stuff. MS's own web sites
also
suffer from the same problem.

I've looked at the few posts I can find about it on here. I'll answer a
few
questions before they are asked:

- All drop down combo boxes have populated themselves okay.
- No I'm not using any conditional formatting on any controls.

The form has tabs on it and one tab has a subform. There are many combos
but
they seem okay. It does have a timer event but that only runs a procedure
a
fraction of a second after the form has loaded - and only runs once.

The "of how many" bit at the bottom of the form does not appear at all -
but
if you jump to the last record it appears immediately (no delay).

As this doesn't impare the operation of the form it's just something that
is
annoying me and I'm wondering if it's due to one of the many updates /
service packs received from MS?

The development of the form in Access 2003 and compiling in 2000 is a bit
non-
standard but that's just how this particular program has been developed in
the past and it's never caused any problems before. At the moment I'm
seeing
this behaviour in the mdb being worked on in Access 2003 - I haven't
checked
it's behaviour in Access 2000 yet.

Paul

A2003 does indeed process calculated fields slower than previous versions.
The solution is to do your calcs in the query feeding the form's
RecordSource (if possible).

Can't offer anything to explain why this is the case, sorry.