Welcome to SPN

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

Sign Up Now!

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]
     

Share This Page