Auto Update a feild every year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi
i have a members Database in MS Access. i have numeric field that related
with CheckBox if check its add a value in numeric feild.....

If Check.Value = True Then
MaintinanceCharges.Value = 1800
ElseIf Chek.Value = False Then
MaintinanceCharges.Value = 0
End If
What i want that... if check then value shuold add automaticly on
01/01/every.year
 
What i want that... if check then value shuold add automaticly on
01/01/every.year
Click to expand...

Without knowing anything about the structure of your database, or what
the meaning of this value is, all I can suggest is: if the value can
be calculated at any time based on the year, then don't store it in
your table at all, but calculate it (based on Year(Date()) to get the
current year) whenever it's needed.

Further explanation on your part might help!

John W. Vinson[MVP]
 
i have a members Database in MS Access. mebers pay their fee every year that
due on 1st January of each year 01/01/0000. i want that if i chek then every
year $45 add in the payable account of the member otherwise dont add. as
under it workin fine """but i need auto update of each year on 1st january"".

If Check.Value = True Then
MaintinanceCharges.Value = 45
ElseIf Chek.Value = False Then
MaintinanceCharges.Value = 0
End If
""""""""""i want add this $45 every 1st january in the members payable
account that i enable by check""""
 
Back
Top