Welcome to SPN

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

Sign Up Now!

How do I make this work

Discussion in 'Information Technology' started by HelpingHospice, Jul 28, 2006.

Tags:
  1. HelpingHospice

    HelpingHospice
    Expand Collapse
    Guest

    Ok, I am entering all of our companies contracts into an access database.
    Some of the contracts are autorenewals and the date needs to be automatically
    updated after the year has lapsed. Question 1: How do I create a check box
    for those which are autorenewals and make it change the dates once that
    passes?

    Also, I am trying to get this to automatically send out an e-mail to the
    signee of the contract when the expiration date is up, How would I go about
    doing this?

    I appriciate your help in advance, thank you.
     
  2. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    >>contracts are autorenewals and make it change the dates once that passes?
    Better than changing the date (Update query) would be a new record on
    renewal. Create a macro named Autoexec so that each time the database is
    opened it checks what needs to be done.
    Use an append query to create renew records. Have a flag field that
    indicates not to renew/renewed. A second query, update query, will set the
    flag after the new record is appended.

    >>I am trying to get this to automatically send out an e-mail to the signee of the contract when the expiration date is up

    The macro can also run select query and e-mail the signee.

    "HelpingHospice" wrote:

    > Ok, I am entering all of our companies contracts into an access database.
    > Some of the contracts are autorenewals and the date needs to be automatically
    > updated after the year has lapsed. Question 1: How do I create a check box
    > for those which are autorenewals and make it change the dates once that
    > passes?
    >
    > Also, I am trying to get this to automatically send out an e-mail to the
    > signee of the contract when the expiration date is up, How would I go about
    > doing this?
    >
    > I appriciate your help in advance, thank you.
     

Share This Page