Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    d9pierce1 is offline Expert
    Windows 10 Access 2019
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    Hi and agaain, thank you so much. As for the weekly, If I choose "Weekly" in the dropdown, and I choose lets say Thursday from the CboWeekDay then I want the NextDepositDay to be the following Thursday.


    So what ever day it is (today), if "Weekly" and its on a Day such as Thursday, the NextDepositDay should show the next Thursday.... as the date.
    Does this make sense? If I make a deposit weekly on a specified day of the week via CboWeekDay, then the NextDepositDay should show the next or follwing week.
    Example:
    Today is 2/17/2023 ("Friday) Then NextDepositDay should be 2/23/2023 if I have Thursday in my CboWeekDay. If lets say today is 2/14/2023 Tuesday, then NextDepositDay should be 2/16/2023 when I have chosen Thursday from my CboWeekDay.

    Hope this clears that up
    Thanks
    Dave

  2. #17
    d9pierce1 is offline Expert
    Windows 10 Access 2019
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    Hi Gicu,
    Let me simplify this.
    And Thank you so much for the other Functions. They will help me out tremendously on my project db i am working on when figuring out calendar and work days in a project among other things. Thanks

    Basically If I choose a Weekly Deposit, and I choose lets say Thursday as the deposit day, what ever today is it should calculate the NextDepositDay to be the following Thursday.
    If it were Monday 2/13/2023 then NextDepositDay would be Thursday 2/16/2023, if today 2/17/2023 then nextDepositDay would be 2/23/2023....

  3. #18
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Hi Dave,

    Here you go, please test and let me know.

    Cheers,
    Attached Files Attached Files
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  4. #19
    d9pierce1 is offline Expert
    Windows 10 Access 2019
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    Hi Gicu,
    Thank you so much! That works like a charm... You are a total Genisus all the way!
    Thank you for sharing your infinite knowledge with me and helping me with this!
    I have been blessed with you and this group. I will mark this solved!!!!!YEAH

  5. #20
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Thanks for the kind words, definitely not infinite knowledge, just a few more years probably, struggling with the same issues....

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 08-23-2018, 01:23 PM
  2. Replies: 2
    Last Post: 03-13-2018, 04:26 AM
  3. Replies: 1
    Last Post: 11-18-2014, 11:19 AM
  4. Replies: 1
    Last Post: 09-04-2014, 10:13 AM
  5. Replies: 25
    Last Post: 11-16-2012, 12:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums