A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Update the Date Field



 
 
Thread Tools Display Modes
  #1  
Old August 27th, 2004, 06:01 PM
Chris Peikert
external usenet poster
 
Posts: n/a
Default Update the Date Field

I am trying to create a form that has 2 date fields. Court Date, and Due
Date. The Court Date is just a basic Date field, but when I exit that field
or enter into the Due Date field I want the Due Date field to be the Court
Date + 45 Days and update automatically. How do I do this. I found an
expression to build using DateAdd ( "d", 45, "date"). I don't know what to
put in for the Date. I tried pointing it to the Court Date field but it does
nothing. Any help would be much appreciated.



  #2  
Old August 27th, 2004, 06:27 PM
Mister G
external usenet poster
 
Posts: n/a
Default

If you name the two text boxes containing the fields txtCourtDate and
txtDueDate and format both as dates, you might use this code that will
execute after you enter a value for court date.

Private Sub txtCourtDate_AfterUpdate()
Me.txtDueDate = Me.txtCourtDate + 45
End Sub

"Chris Peikert" wrote:

I am trying to create a form that has 2 date fields. Court Date, and Due
Date. The Court Date is just a basic Date field, but when I exit that field
or enter into the Due Date field I want the Due Date field to be the Court
Date + 45 Days and update automatically. How do I do this. I found an
expression to build using DateAdd ( "d", 45, "date"). I don't know what to
put in for the Date. I tried pointing it to the Court Date field but it does
nothing. Any help would be much appreciated.




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Date field - No update Tony Mailmerge 2 July 22nd, 2004 05:45 PM
ASK Field Behavior Greg Mailmerge 9 July 2nd, 2004 02:44 PM
NUMBERING the pages Bob New Users 7 June 14th, 2004 12:20 AM
Does date fall between two ranges? MR Worksheet Functions 4 January 14th, 2004 05:08 PM
How to calculate 12 months from "Date Added" field Sandi Gauthier Worksheet Functions 2 November 19th, 2003 06:01 PM


All times are GMT +1. The time now is 09:34 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.