Overstay2 module

The Overstay2 module is VBA module contains the code used to implement the functionality for the processes documented at Overstay2 Overview. There is a branch for this in the Git repository but the general change log is at Log and CFE Log.

Details

Exposes the following functions used by CCMDB.accdb:

• Public Function Handle_Overstay_Button(ID As Variant) As Boolean
• Public Function Set_Overstay_Button_Colour(Overstay_Colour As Double) As Boolean
• Public Function Get_Existing_Overstay_Result(ID As Variant) As Double
• Public Function Get_Overstay_Parameters_from_ID(ByVal ID As Variant, ByRef op As Overstay_Parameters) As Boolean
  • implements Data definition for factor candidates for the Overstay2 project

Contains additional functions to generate results from data in CFE, low use so see code.

Use in both Centralized data front end.accdb and CCMDB.accdb

The same code is used for both CCMDB and CFE, with a single modifier value required to tell which program it is being run from, one of:

• #Const in_CFE = True
• #Const in_CCMDB = True