button to advance date by one year

[Minty]

Yes it works - you would need to "enable content" when you open it, as by default any downloaded files won't run any code.

 

[premint]

thats great thanks a lot it works now, much appreciated

 

[Galaxiom]

Sorry to chime in so late and spoil the party but the wise developer wouldn't have a button to increment a value in a field. Working like this leaves no trail to verify the correct answer because there is no record of the button presses.

Instead, record the events that would have caused the value to increment then calculate the current value by accounting for those records. This is a fundamental principle of good design.

So in your case, you need to record the renewals in another table then calculate the next renewal date from those records every time it is required.

 

[premint]

hello galaxiom, thanks for your advice, i take your point and it is good advice, but i think at this time its way beyond my capabilities, unless you can provide comprehensive instructions on doing this in which case i would be happy to have a look at doing it