Update Old Records

[GAB]

Hi,

This may be a stupid question, but, If I make a change to the design on a form and I want to update previous records to incorporate the change I made how would I go about making this happen automatically without having to go into each old record manually? An example is I just changed a formula I was using to a macro using the setvalue option and a formula in it and I had to manually update the old records. Any ideas on this?

Thanks,

Gary

 

[CEH]

Search Access help, or here, on "update query". That might fit your needs.

 

[GAB]

Hi Curtis,

I already have searched Access help, this forum and another I belong to. Since the form I am using is doing a calculation and the setvalue macro is causing the results to be saved on a table I need the update to happen from the form. I didn't see, and I certainly could be very wrong on this, how an update query would help me? I actually need the form to do the work.

Gary

 

[GAB]

This is an excellent example of why you shouldn't be storing a calculated value in your table. Change the calculation so that it only displays its result on the form rather than storing it.

Nope,

Have to store the value in the table. Long Story. It goes way back and way deep on how I initally built the data base. ( Too late to change it now). If there's no other solution than I will manually do the changes. It's only a one time thing.

Thanks anyway.

Gary

 

[missinglinq]

I already have searched Access help, this forum and another I belong to. Since the form I am using is doing a calculation and the setvalue macro is causing the results to be saved on a table I need the update to happen from the form. I didn't see, and I certainly could be very wrong on this, how an update query would help me? I actually need the form to do the work.

Gary

Using an update query you can recalculate your stored field using the fields originally used for the calculations plus your new formula. The query will do the work for you, rather than going into each record and doing the recalculations one at a time.

 

[GAB]

The way the calculation is being made on the form is using a setvalue macro with a formula ( =[T1]/16/8.44*[LB1]*[A1]) to calculate the field. I don't understand how an update query would accomplish the same calculations? I know this is my ignorance so as usual any help is always greatly appreciated.

Gary