 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / June 2007Simple maths
I have this suform with this control InQty, OutQty, TotalQty (In- Out Qty) Example of data Iteml | InQty| OutQty| TotalQty ABC 4 1 3 CDE 10 5 5 Since the value of the InQty will be loaded in from excel, so when I open the subform, I would like to generate all the total quantity all when loaded. All controls are bound.... However, I tried to put in form load, but it can only work for the first record. Any help? Put it in OnCurrent event. Steve > I have this suform with this control InQty, OutQty, TotalQty (In- Out Qty) > [quoted text clipped - 13 lines] > > Any help? You mean put in form on Current? If that is the case, I have tried it before, it can only work when the user select to the current record. Isn't a bit troublesome, only get to see the result when the user select the current record especially my case is, the data is loaded in? Is there any way, is will calculated once the form is being loaded? >Put it in OnCurrent event. > [quoted text clipped - 5 lines] >> >> Any help? On Jun 28, 5:00 am, "EMILYTAN via AccessMonster.com" <u33296@uwe> wrote: > You mean put in form on Current? > If that is the case, I have tried it before, it can only work when the user [quoted text clipped - 15 lines] > -- > Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200706/1 Put it in the On Load and if that still doesn't help delay it further by putting it on the on activate >I have this suform with this control InQty, OutQty, TotalQty (In- Out Qty) > [quoted text clipped - 11 lines] >However, I tried to put in form load, but it can only work for the first >record. Try putting the calculation in the subform's record source query.  SignatureMarsh MVP [MS Access] Because I am doing calculations using DLookUp, so its better to do it using VBA... >>I have this suform with this control InQty, OutQty, TotalQty (In- Out Qty) >> [quoted text clipped - 4 lines] >Try putting the calculation in the subform's record source >query. Because I am doing calculations using DLookUp, so its better to do it using VBA... >>I have this suform with this control InQty, OutQty, TotalQty (In- Out Qty) >> [quoted text clipped - 4 lines] >Try putting the calculation in the subform's record source >query. Because I am doing calculations using DLookUp, so its better to do it using VBA... >>I have this suform with this control InQty, OutQty, TotalQty (In- Out Qty) >> [quoted text clipped - 4 lines] >Try putting the calculation in the subform's record source >query. |
Reply to this Message |
 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.