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 / April 2008

Tip: Looking for answers? Try searching our database.

Result not stored in the table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jalal - 10 Apr 2008 10:36 GMT
I modified the customer template database that available from Microsoft
Online as per my requirement.
in the table case. I add new fields, 1st [Price / Qauntity], 2nd [Qauntity],
3rd [Total Price].
now in the case detail form I add those fields, but in the [Total Price] I
made formula that will calculate [Price / Qauntity]*[Qauntity]. but I
surprised there is no result in the case table

Regards
Rick Brandt - 10 Apr 2008 12:26 GMT
> I modified the customer template database that available from
> Microsoft Online as per my requirement.
[quoted text clipped - 6 lines]
>
> Regards

Surprised?  The method for getting a control to store its value in a field
is to place the name of the field in the control's ControlSource property.
You have not done that.  You have an expression in there.  A control is
either bound to a field OR contains an expression.  It cannot do both.

The good news is that proper database design dictates that you should not be
storing that value in your table anyway.  Just remove that field from your
table and any place you need to see that value use the expression you are
using now in your form.

Tables should contain raw data only, not data that can be derived from other
data.  That is the job of queries, forms, and reports to calculate in real
time as needed.  That way there is never any doubt as to its correctness.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

 
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.