Thanks thanks thanks and big thanks to you !!!
Mr Neopa,
Millions thanks to you for assisting me on solving my prob. With the codes given, I finally managed to complete my On Leave App. I've also done with my presentation to my GMD just now, he's 100% satisfied and ups for admin use.
You saved my day! Thanks to Bytes!!!...
ayinky
Last Activity: Mar 11 '12, 03:26 AM
Joined: Feb 13 '12
Location: Malaysia
-
From the earlier on, I'm just trying to pin the problem on the one I've put in Bold ...
"(6). DaysOnleave (this field is used to save result/value no. (5) as its field data, bound, this is the problem I faced)"
i.e the best method on keeping the unbound calculated value (5) into bound field (6).
...seems I'm a newbie in this VBA coding and trying to benefit the advantages of it in our daily office...Leave a comment:
-
Here goes the details as I can source it out for you:
Form name : FOnLeave
Table name : TOnLeave
Field list (all textboxes):
(1). OnLeaveID (used as for the Relationship - Auto)
(2). StartDate (the start date on leave - short date, manual entry)
(3). EndDate (the last date on leave - short date, manual entry)
(4). NumPublicDay (the number of public holidays, manual entry)
(5). CalcDaysOnLeave...Leave a comment:
-
I'm really sorry for going against the norm but the app & co. practice requires me doing so.
Well then, what AfterUpdate coding should I use to apply the value from unbound textbox (5) into bound textbox (6)? I'm figuring on INSERT INTO but have no idea on the coding structure (I'm not a programmer or system developer/analyst, just trying to computerise whichever manuals in my co.) - let's say the tablename : TOnLeave.
...Leave a comment:
-
Just for your info, I've completed the app structure, login form, entry forms, reports etc except this no. (6) data that makes me stuck for days. I have only 2 days left to present to my Group Managing Director before attending a 3 days managerial course abroad.
I'm really sorry for this such a problematic thing I come up with. I truly have no clue on solving this matter.Leave a comment:
-
I got what you meant. May be I need to re-clarify the reason why I really need to store it. Its main purpose is to let admin know the record of how many days someone take leave. Normally, at the end of every month, the admin will re-check days on leave for every person. He/she needs to know for his/her report: how many days on leave brought forward from last year, how many days eligible for that particular year, total days on leave available for...Leave a comment:
-
Its not the calculation that matters me. The idea is that I want to have the result/value (5) saved in a table. I'm expecting for VBA code or something that may be I can place on the AfterUpdate or anything...
Sorry for the incomplete info provided...Leave a comment:
-
Thanks for your respond.
I'm aware of the Normalisation method, however I need to have the value (5) kept in a field (6) so that I can always refer it for next calculation, report views etc.
In that case, is there any better solution for me to follow seems what I want is that just right after the user entered data (7), (8),(2), (3) and (4), result (5) will automatically generated. Then comes result (9).
Tha...Leave a comment:
-
How to automatically save a VALUE into a table field?
Hi
I am developing an On Leave app. in which trying to calculate employees days on leave.
I have created a Form consists of this fields (from a table):
(1). OnLeaveID (used as for the Relationship - Auto)
(2). StartDate (the starting on leave date - short date)
(3). EndDate (the last date on leave - short date)
(4). NumPublicDay (the number of public holidays)
(5). CalcDaysOnLeave (calculate...
No activity results to display
Leave a comment: