Date problems

[badboy2005]

Ok.. its been a while since i last used VB in Access and i got a bit rusty, and tbh i remember nothing

Am trying to figure out a script to use in a field ( Due Return Date ), that will take a Date value from a specific field (Date Loaned) and will add 2 to the date.

E.g Date Loaned: 26/10/2006

With the code, Due Return Date to display: 28/10/206

thnx

 

[systemx]

I hav'nt tested this..but it should work.

Dim MyDate As Date

MyDate = Me.MyTextbox1.Value
MyDate = MyDate + 2
Me.MyTextbox2.Value = MyDate

Or something along those lines...

 

[Bat17]

as it is just a calculation you don't really need to store it, so you can always calculate it on the fly in query/report/form =[Date Loaned]+2

peter