Setting up a specific date

[Guest]

I have a "Date Sent" field and "Date Due" field. I want to have the "Date
Due" field automatically set 15 days from the "Date Due" field. So if I
enter 09/18/06 in the Date Sent field the Date Due will automatically state
10/02/06. Any Ideas???

 

[David Pawloski]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

David Pawloski
Microsoft MVP

 

[Guest]

Well that is a bunch of.....

Ok thank you.

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

David Pawloski
Microsoft MVP

 

[John Spencer]

Ignore the reply from David Pawloski - it is spam

If the DateDue field is always 15 days from the date sent field, don't store
it. Just calculate it when needed using

DateAdd("d",15, DateSent)

If, on the other hand, the DateDue field is normally 15 days, but in some
case it will differ then in the form, you can use vba to populate the
DateDue control when DateSent is entered. Using the AfterUpdate event of
DateSent the UNTESTED AIRCODE might be.

Private Sub DateSent_AfterUpdate()

If IsDate(DateSent) then
Me.DateDue = DateAdd("d",15,Me.DateSent)
End if

End Sub