Search results

  1. A

    Sum of Subform Values And Store In MainForm Field

    Actually when I execute the whole code thru save cmd btn, the sum amount on main from field for a fraction of second and default value of field Me.Amount which is set as zero (0) is saving in the main table. Thats why I saved invoice value in a temp variable and then saved to tbl
  2. A

    Sum of Subform Values And Store In MainForm Field

    I did it in a very simple way in above code like this. These 3 lines I please at very beginning of code and it worked without further coding. Dim X As Integer X = Me.Amount rst!Amount = X And thats all. May be there is another way with strong coding but this worked for me well. But still I am...
  3. A

    Sum of Subform Values And Store In MainForm Field

    Bcz I will clear the invoice amount to 0 in "Payment Receipt Master " once received from client.
  4. A

    Sum of Subform Values And Store In MainForm Field

    Thanks Bob, That I did already and showing me total value of subform onto the main form. But I need that total value to be stored in Main form's table in relevant invoice record. This invoice value shall be adjusted in future somewhere.
  5. A

    Sum of Subform Values And Store In MainForm Field

    Hi, I have main form (F_CrSalesInvoice) and subform ( SF_CrSalesInvoice_Footer) for invoicing. with InvNum in both forms related with one-to-many. Other than many fields my main form contains a field called "Amount". When I save the invoice I want to sum total records from subform where...
  6. A

    Solved Looking For Loop To Count Total Actual Days From 2 Dates

    Arnel, It Is Absolutely Brilliant ....... its R..o..c..k..i..n..g....(y)(y)(y) I have added few lines (at the check point) to avoid null / zero value as per my requirements and it produces EXACT Yrs, Months & Days as desired. I really appreciate all the members here who supported me on this...
  7. A

    Solved Looking For Loop To Count Total Actual Days From 2 Dates

    I will try your above code Arnel and will revert back to you.. Thanks a lot
  8. A

    Solved Looking For Loop To Count Total Actual Days From 2 Dates

    Business month of 30 days was the previous setting. But recently law has been amended and they require counting the calendar months with 28, 29, 30, or 31 days for each month according to the calendar. Therefore, my problem is to get exact yr month n days.
  9. A

    Solved Looking For Loop To Count Total Actual Days From 2 Dates

    @The_Doc_Man, I understand it is messy. But just curious to know how this website : https://www.timeanddate.com/date/durationresult.html?d1=25&m1=10&y1=2020&d2=24&m2=07&y2=2022&ti=on Produces the below with is accepted by Saudi Government From and including: Sunday, 25 October 2020 To and...
  10. A

    Solved Looking For Loop To Count Total Actual Days From 2 Dates

    I took first date Oct 25, 2020 and End date Aug 24, 2022. In this case total days are 669 which is 100% correct. but when it converts in year month and days it displays 1 yr, 10 Mnths and 04 Days where as It should be 01 Year and 10 Months. So difference is 4 days at converting into yr, mnth &...
  11. A

    Solved Looking For Loop To Count Total Actual Days From 2 Dates

    Thanks Arnel, You code is far closer. I am trying to set it in my db and reduce 2 days from total days while testing with diff dates. Hopefully I could manage it and once done I will come back Many thanks....
  12. A

    Solved Looking For Loop To Count Total Actual Days From 2 Dates

    The parameter value are already on form and instead of DtStart and DtEnd, I replaced with CExpDateOfJoining, LastWorkingDay and then triggering to executed the function.
  13. A

    Solved Looking For Loop To Count Total Actual Days From 2 Dates

    Arnel, You code is almost close to the desired result. I want my From and To dates to pickup from forms (CExpDateOfJoining & LastworkingDay) and produce the result. To get this I just placed one text box and a new cmnd btn under which I called the function as follows: (I changed the ESB...
  14. A

    Solved Looking For Loop To Count Total Actual Days From 2 Dates

    Arnel, Your code supports for American date format I tried changing module name and immidate window show me following effect with British and American date format. ?testesb(#09/10/2017#,#05/31/2022#) 4 year(s) 8 month(s) 25 day(s) ?testesb(#10/09/2017#,#31/05/2022#) 4 year(s) 7 month(s) 26...
  15. A

    Solved Looking For Loop To Count Total Actual Days From 2 Dates

    Even I changed the function name. had saved it in std moudule, same error
  16. A

    Solved Looking For Loop To Count Total Actual Days From 2 Dates

    I saved your code in Std module and called under on click even of a button as follows: Call ESB it produced "Invalid Use of Property"
  17. A

    Solved Looking For Loop To Count Total Actual Days From 2 Dates

    Thanks Arnel, You are correct it is up to May so 151 days in 2022 Let me check your code....
  18. A

    Solved Looking For Loop To Count Total Actual Days From 2 Dates

    Thanks you plog for your efforts to solve the issue. 4 years, 8 months, 22 days is the correct calculated days from the period given. I am calculating End Of Service Benefit of employees. It the yrs, months and days are wrong then EOSB of will be wrong..isnt it? Therefore, I need to count...
  19. A

    Solved Looking For Loop To Count Total Actual Days From 2 Dates

    Hi, I have 2 date fields as follows : CExpDateOfJoining LastWorkingDay Example: 10/02/2017 as CExpDateOfJoining 31/05/2022 as LastWorkingDay I m looking for a Access VBA Code loop (possibly using Do While) that will count actual days in that year Means: Year 2017 from 10 Feb 2017 to 31 Dec...
  20. A

    Form btns of Access 2007 not working in Access 2016

    Even procedure are there with btns but still nothing
Back
Top Bottom