On button press should update the year

[jamril]

Dear all,

I just confuse for VBA code, that is, in Access form text box contain year, nearby i put on button named update, so when I press the button year should be increase to next year.. ex Text box data is 01/01/2012, so when i will press the button text box data should be changed to 01/01/2013,,

I tried some codes but I failed



Plz can any one help in these code??

Thanks in advance

[June7]

Are you changing date value for existing records? Why would you do that?

Use DateAdd function to add a year. Show your attempted code.

Beware user error. If user accidentally repeatedly presses button, the date will be repeatedly incremented. And what if user forgets to press button when they should?

[alansidman]

This worked for me.

Private Sub Command2_Click()
Dim dTxt As Date


dTxt = DateAdd("yyyy", 1, Text0)
Me.Text0.Value = dTxt
Me.Requery


End Sub

Edit: All good points made by June if you go down this road.

[jamril]

Thankyou alansidman,,,,,,, your formula is working fine,, Thankyou once again.....