Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / December 2007

Tip: Looking for answers? Try searching our database.

Saving Control Calculated Fields To Tables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Roberto - 06 Dec 2007 20:13 GMT
I'm trying to save the calculated result of a control "=[grossPay]*.062" into
a table.  The form will only save bound user-entered fields to the table.  I
would like to have all of the data, even calculated fields saved to the
table.  Is there a way to save unbound form fields to a table?
Klatuu - 06 Dec 2007 20:27 GMT
a control has to be bound to a field for the field to be updated (without
some code).

My guess is that your formula is in the control source property of the
control.
There are a couple of things you can do.
1. Move the formula to the default value property of the control.  The issue
here is that if you change the value of the [gross pay] control, it will not
update the new value.  The Default Value only works for new records.

2.  Move the formula to the After Update event of the [gross pay] control.  
With this method, the other control will update any time you change the value
in the [gross pay] control.

Signature

Dave Hargis, Microsoft Access MVP

> I'm trying to save the calculated result of a control "=[grossPay]*.062" into
> a table.  The form will only save bound user-entered fields to the table.  I
> would like to have all of the data, even calculated fields saved to the
> table.  Is there a way to save unbound form fields to a table?
John W. Vinson - 06 Dec 2007 23:23 GMT
>I'm trying to save the calculated result of a control "=[grossPay]*.062" into
>a table.  The form will only save bound user-entered fields to the table.  I
>would like to have all of the data, even calculated fields saved to the
>table.  Is there a way to save unbound form fields to a table?

Storing derived data such as this in your table accomplishes
three things: it wastes disk space; it wastes time (almost
any calculation will be MUCH faster than a disk fetch); and
most importantly, it risks data corruption. If one of the
underlying fields is subsequently edited, you will have data
in your table WHICH IS WRONG, and no automatic way to detect
that fact.

Just redo the calculation whenever you need it, either as a
calculated field in a Query or just as you're now doing it -
in the control source of a Form or a Report textbox.

If you want to store this calculated result, KNOWING THAT IT WILL BE WRONG at
any point that either the stored value or the grosspay gets edited, use the
Form's BeforeUpdate event to copy the value from the calculated control into a
bound control. Don't call me in as a witness when your employee sues you for
witholding the wrong amount of tax though, that's *your* problem.

            John W. Vinson [MVP]
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.