Rollover procedures

Rollover takes place between June and July of each year. Rollover procedures are required to change several queries, etc., to make usage data load to the appropriate year.

• The main table, totalPdlsrvy, must have a new field added: USE_07_08 (replacing "07" and "08" with the appropriate years.)
• Create an Update Query and "zero out" the field. See Word documentation.
• The "Update Uses" query must be changed so that print usage uploaded from the scanner is added to the field for the new usage year.
• frmAllData needs to be updated to include a field for the current usage year, and the oldest usage field can be deleted from this form. The six most recent years are currently displayed on the form.
• What needs to be done for the online stats upload?

The following no longer need to be updated at rollover:

• The default year on the Reports Menu is automatically set in the VBA code of the form. The following text in Sub Form_Open sets the default year to the current calendar year: Forms![frmReportsMenu]![txtUsageYear].DefaultValue = Get_CurrentUseYear(). Get_CurrentUseYear() refers to a function in the Global Module that returns the current calendar year if the month is between January and June, and the following calendar year if the month is between July and December.
• Because the dates on the reports are set dynamically according to the date specified on the Reports Menu, they no longer need to be edited at rollover.

Back to Use Study Database documentation