Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Follow Up Date

Discussion in 'Information Technology' started by Jose Aleman, Nov 17, 2005.

Tags:
  1. Jose Aleman

    Jose Aleman
    Expand Collapse
    Guest

    Hi,

    I have a follow up field that I want an automatic date after a loan has been
    received.

    For Example:
    LOAN_REC_DATE FOLLOW_UP_DATE
    01/01/2006 01/05/2005

    The follow up date needs to be 5 or 10 days after the receive date. It's
    easy for the user to enter the date but sometime they forget or don't want to
    count days. I want access to assign the date for them automatically.

    Thanks
     
  2. Loading...


  3. ldiaz

    ldiaz
    Expand Collapse
    Guest

    put something like this in your field:

    [ FOLLOW_UP_DATE] = [LOAN_REC_DATE]+10 ' if you want 10 day after
    [ FOLLOW_UP_DATE] = [LOAN_REC_DATE]+5 ' if you want 5 day after


    if my answer was correct clicl YES in:

    """"Was this post helpful to you?"""

    Thanks
    ldiaz



    "Jose Aleman" wrote:

    > Hi,
    >
    > I have a follow up field that I want an automatic date after a loan has been
    > received.
    >
    > For Example:
    > LOAN_REC_DATE FOLLOW_UP_DATE
    > 01/01/2006 01/05/2005
    >
    > The follow up date needs to be 5 or 10 days after the receive date. It's
    > easy for the user to enter the date but sometime they forget or don't want to
    > count days. I want access to assign the date for them automatically.
    >
    > Thanks
     
  4. ldiaz

    ldiaz
    Expand Collapse
    Guest

    you need to put just this in your form field named "FOLLOW_UP_DATE":
    [LOAN_REC_DATE]+10 or
    [LOAN_REC_DATE]+5

    I put this, to let you know what this formula makes..
    [FOLLOW_UP_DATE] = [LOAN_REC_DATE]+10

    where [FOLLOW_UP_DATE] is the fieed where it needs to go this
    statements:[LOAN_REC_DATE]+10

    Thanks
    ldiaz

    "Jose Aleman" wrote:

    > I wrote your command under Default Value and I see the following the field.
    > #Error
    >
    > I also wrote it under After Update as a procedure but it didn't work.
    >
    > Do you think I should create the form based on a query instead?
    > "ldiaz" wrote:
    >
    > > put something like this in your field:
    > >
    > > [ FOLLOW_UP_DATE] = [LOAN_REC_DATE]+10 ' if you want 10 day after
    > > [ FOLLOW_UP_DATE] = [LOAN_REC_DATE]+5 ' if you want 5 day after
    > >
    > >
    > > if my answer was correct clicl YES in:
    > >
    > > """"Was this post helpful to you?"""
    > >
    > > Thanks
    > > ldiaz
    > >
    > >
    > >
    > > "Jose Aleman" wrote:
    > >
    > > > Hi,
    > > >
    > > > I have a follow up field that I want an automatic date after a loan has been
    > > > received.
    > > >
    > > > For Example:
    > > > LOAN_REC_DATE FOLLOW_UP_DATE
    > > > 01/01/2006 01/05/2005
    > > >
    > > > The follow up date needs to be 5 or 10 days after the receive date. It's
    > > > easy for the user to enter the date but sometime they forget or don't want to
    > > > count days. I want access to assign the date for them automatically.
    > > >
    > > > Thanks
     
  5. Jose Aleman

    Jose Aleman
    Expand Collapse
    Guest

    I wrote your command under Default Value and I see the following the field.
    #Error

    I also wrote it under After Update as a procedure but it didn't work.

    Do you think I should create the form based on a query instead?
    "ldiaz" wrote:

    > put something like this in your field:
    >
    > [ FOLLOW_UP_DATE] = [LOAN_REC_DATE]+10 ' if you want 10 day after
    > [ FOLLOW_UP_DATE] = [LOAN_REC_DATE]+5 ' if you want 5 day after
    >
    >
    > if my answer was correct clicl YES in:
    >
    > """"Was this post helpful to you?"""
    >
    > Thanks
    > ldiaz
    >
    >
    >
    > "Jose Aleman" wrote:
    >
    > > Hi,
    > >
    > > I have a follow up field that I want an automatic date after a loan has been
    > > received.
    > >
    > > For Example:
    > > LOAN_REC_DATE FOLLOW_UP_DATE
    > > 01/01/2006 01/05/2005
    > >
    > > The follow up date needs to be 5 or 10 days after the receive date. It's
    > > easy for the user to enter the date but sometime they forget or don't want to
    > > count days. I want access to assign the date for them automatically.
    > >
    > > Thanks
     
  6. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 16 Nov 2005 09:40:58 -0800, "Jose Aleman"
    <JoseAleman@discussions.microsoft.com> wrote:

    >Hi,
    >
    >I have a follow up field that I want an automatic date after a loan has been
    >received.
    >
    >For Example:
    >LOAN_REC_DATE FOLLOW_UP_DATE
    >01/01/2006 01/05/2005
    >
    >The follow up date needs to be 5 or 10 days after the receive date. It's
    >easy for the user to enter the date but sometime they forget or don't want to
    >count days. I want access to assign the date for them automatically.
    >
    >Thanks


    How do you decide whether it's 5 or 10 days? Is there some other field
    in the table which determines this, such as the LoanType? If so, try
    putting a Textbox on the form with a Control Source

    =DateAdd("d", IIF([LoanType] = "Foo", 5, 10), [Loan_Rec_Date])


    John W. Vinson[MVP]
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page