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 and CFE:

• 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

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

Contains additional functions to generate results from data in CFE, low/testing only 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