how to automatically generate feevoucher every month

[ijaz1976]

hi i am new to access
i created a student info database and want to generate fee voucher automatically every month. now i can updated some fields like "monthly fee", "van charges", "security charges" etc based on classes table which includes all these fields but in future if i change any value in classes table all old records will be updated automatically which i do not want. i want to apply changed amount only on new records
please help

 

[NigelShaw]

hi i am new to access
i created a student info database and want to generate fee voucher automatically every month. now i can updated some fields like "monthly fee", "van charges", "security charges" etc based on classes table which includes all these fields but in future if i change any value in classes table all old records will be updated automatically which i do not want. i want to apply changed amount only on new records
please help

without seeing what you are talking about, its hard to say but what you could do is add a boolean option to your table.

True = update
False = Don't update.

All new records would beset to true until such a time that you or your code changes it to false pending on specific criteria. Eventually every new record becomes an old one so to speak.


Cheers

Nigel

 

[evanse]

pls i am jst a beginner, i need to help me build on practices