Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Automatic Renewal tracking

    I have a form with a continous subform in it. The subform consist of a final date and the rest of the field are renewal date its suppose to look like this

    Final = 01/02/2000
    renewal = 01/31/2002
    Secondrenewal = 01/31/2004
    etc..ect

    the renewals are always suppose to be at the end of the month and every two years from the final date. I just want the users to put in the final date and then have the fields populate themselves (no repeating values) automatically exactly like the example above is this possible???

    I did some reasearch and I was thinking I could just have the final date and the firstrenewal date in the query have this dateserial code
    =DateSerial(Year([FIRSTRENEWALDATE])+2,Month([FIRSTRENEWALDATE]),Day([FIRSTRENEWALDATE])). I was thinking of setting this up in a query. then placing it in my subform which is continous.

    Thank you

  2. #2
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259
    why go through all that trouble for a query; just use some splash of VB to do that for ya..

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unfortunately

    I dont know alot about vb so I'm not a programmer. I am taking some classes next semester but that wont help me now.

    Thanks anyways for the reply

  4. #4
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259
    is it ok if i write out the code for you and the instructions to put it?

  5. #5
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259
    its not that hard really! i'can explain my code too...

  6. #6
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Smile THANK YOU

    I would appreciate that so much, you are so awesome for doing that. I dont know how to thank you. If it doesnt take up too much of your time I sure would appreciate it..

  7. #7
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    explainations will help out alot since I will be taking vb next semester
    thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •