Problem with recalc in XP

[Gaffer]

Hi

I'm working on a database, which has been developed on Access 97 and is comprised of one form containing a multitab, and many subforms within that. There are also about 12 text boxes over the form which contain lookups and calculations of one sort of another. Now, all of this seems to work fine on Access 97.

One of the things I need to do to this database is to upgrade it to Access XP. When I've attempted to do this, I'm having repeated crash difficulties. When selecting a certain page of the multitab, the Recalc command is used. This is the point at which it crashes. It seems to be having a problem with the formulae on the form, as when I remove them, it no longer crashes. However, there appears to be nothing actually wrong with them, and they all worked fine in 97.

At this stage I'm unsure how to proceed. Is there an issue with Recalc in Access XP?

Thanks

 

[Ian Mac]

Hi

I'm working on a database, which has been developed on Access 97 and is comprised of one form containing a multitab, and many subforms within that. There are also about 12 text boxes over the form which contain lookups and calculations of one sort of another. Now, all of this seems to work fine on Access 97.

One of the things I need to do to this database is to upgrade it to Access XP. When I've attempted to do this, I'm having repeated crash difficulties. When selecting a certain page of the multitab, the Recalc command is used. This is the point at which it crashes. It seems to be having a problem with the formulae on the form, as when I remove them, it no longer crashes. However, there appears to be nothing actually wrong with them, and they all worked fine in 97.

At this stage I'm unsure how to proceed. Is there an issue with Recalc in Access XP?

Thanks

I'm unsure of Recalc issues, but have you tried putting them back in one by one.
You can then find the culprit post the Code/Formula here for a clearer picture of what is happening.

Regards,

 

[Gaffer]

Sorted it! I isolated it to three text boxes containing formulae that Access XP didn't like. They all referenced text boxes that had the same name as the fields that the were bound to. Explicitly referring to the controls sorted this problem out and they work fine now.

Just as an example if anyone else ever has this problem. Excuse naming conventions, this is how it came:

=Nz([Forms]![main_entry]![voice_entry]![company_discounted_handsets]![discounted_handset_ec],0)+([cmp_ec_pcn_allowance]*IIf([cmp_ec_all_pcns],[Forms]![main_entry]![voice_entry]![Deal_Specifics]![cmp_no_activations],[cmp_ec_no_pcns])/[Forms]![main_entry]![voice_entry]![Deal_Specifics]![cmp_no_activations])

I'm quite intreagued at why Access 97 was able to handle them, but XP just crashed.