Overstay2 module: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
The Overstay2 module is the VBA module that encodes the [[Overstay2 scoring models]]:
The {{PAGENAME}} is VBA module contains the code used to implement the functionality for the processes documented at [[Overstay2 Overview]]. The code base is in the [[Git repository]] but the general change log is at [[Log]] and [[CFE Log]].
* [[Overstay2 data processing and reporting in CFE]] in [[Centralized data front end.accdb]]
* [[Overstay2 Score and colour generation in CCMDB]]  in [[CCMDB.accdb]] 
See [[Overstay2 Overview]] for more context.  


== 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
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:  
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_CFE = True
* #Const in_CCMDB = True
* #Const in_CCMDB = True
The code base is on github at https://github.com/squirrelslair/CCMDB/blob/main/Overstay2.bas
This should provide detailed diffs, but the general change log would be at [[Log]] and [[CFE Log]].


== Related articles ==  
== Related articles ==  

Revision as of 12:00, 23 June 2025

The Overstay2 module is VBA module contains the code used to implement the functionality for the processes documented at Overstay2 Overview. The code base is 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

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

Related articles

Related articles: