Ok let me tell you what is that i want to happen.
there is a table A that which collects user data on a daily basis for 5 users.
that means each day 5 new rows are added for 5 users with default col values = 0.
even if the user forgets to enter values for that day the values should be set to 0.
So finally one day when someone generates a report for that user and his data. it should display all the 30 days with either 0 or the value which the user entered.
You can create a table to store a date. It just needs one field and only needs to store one record.
Create a date trigger to activate as soon as the application is opened each day. This event will have to be tied to the startup form. Note: if the application is not opened it will not run.
Once the code to add the values has been run. change the value in the date table to the current date. Therefore the system will check that table first to see when the event was last run.
You may be able to run it for each day since that date and update the date to the current date when finished.
If the date in the table is the current date then the event will not run. Therefore the event will only run once.