Set default value in field property

[dcjjlove]

My access db is used to compile payroll time records bi weekly. The Work Hours table is used to hold two weeks of time records then they are archived to a history table. Each week has its own week ending date.
I have been updating the default value of the week ending manually in the table field property in the table's design view.
Is there a way to have a macro update this default value?

The current process is, open table in design view, update week ending default value, enter payroll time then change default value again for second week ending, enter payroll time. Report hours to accountant, archive table to history table.

 

[gemma-the-husky]

you would be better using a form rather than entering the date in the table directly. you could easily have a button to add a week to the date, or pick todays date, or even give you an interactive calendar.

generally, there ought to be no need to archive previous weeks data. simple queries can filter the data to select the weeks in which you are interested. that way, all your data is in one place, and you avoid a proliferation of archive copies. and if you find you do need data for a bigger period than 2 weeks, its all available