Recalculate all formulas

[fbicfc]

Hi,

Using Access 2000.

I am working on upgrading a database for a client and have come up against a bit of a problem during the final phase.

What I am trying to accomplish is to take the records from the existing(non-upgrade) database and copy them into the upgraded version.

The copying of the records is not the problem it is getting the new calculation to run over the entire copied dataset as there are now a lot of new fields that calculate positive/negative results to give a Yes/No answer in some separate fields and these fields are used in reports, the only way of updating the fields is to go into them individually and re-enter the dates so that the calculation which is based on the 'After Update' event does the calulation.

Basically what I need to know is: Is there a similar function in Access 2000 to the recalculation function in Excel, and if so how do I get it to run.

Any help is appreciated.

TIA

FBICFC

 

[PHV]

You may consider an Update query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[RoyVidar]

Hi!

I'm not entirely sure if you talk about fields (residing in tables) or controls (thingies on forms and reports), but if it is the latter, perhaps...

If these are form controls with calculated control source, then issuing

[tt]me.recalc[/tt]

should recalculate all calculated controls.

If the calculations are performed in the After Update of controls, you might perhaps try performing the calculations in the forms on current event too.

Roy-Vidar