_Global module

This module contains some code that is the same in Centralized data front end.accdb and CCMDB.accdb.

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 Centralized data front end.accdb: Public Function ID_name() As String Public Function ID_query(Optional ID As Variant = Very_high_number) As String ' optional to allow for more explicit error handling

• Public Function version()
• Public Sub Delay(PauseTime As Integer)
• Public Function Refresh_table(external_tablename As String, internal_tablename As String, data_path As String) As Boolean
• Public Function ExistsTable(table_name As String) As Boolean
• Public Function real_chars(s As String) As Boolean
• Public Function Charlson_score_function(ID As Variant) As Integer
• Public Sub compact_runner(olddb)
• Public Function find_last_slash(s) As Integer
• Public Sub CreateMail(Optional subject As String = "", Optional body As Variant = "", Optional to_address As Variant = "", Optional cc_address As Variant = "")
• Public Function CreateRelation(primaryTableName As String, _
• Public Function GetSQLFromQuery(strQueryName As String) As String
• Public Function fiscal_year(Optional d As Date) As Integer
• Public Function runQuery(q As String) As Boolean
• Public Function roundToMinutes(dtm As Date) As Date
• Public Function stripSeconds(varTime As Variant) As Variant
• Public Sub err_logger(ByRef e As ErrObject, module As String)
• Public Sub LogIt(Optional it As String, Optional argFile As String)
• Public Sub handle_err() 'the_err As ErrObject)
• Public Function has_dx_category(ID As Variant, category As String) As Boolean
• Public Function has_dx_in(ID As Variant, in_string As String) As Boolean
• Public Function has_adm_como_dx_in(ID As Variant, in_string As String) As Boolean
• Sub ListModuleEntities(moduleName As String)
• Sub DumpAllQueries_UTF8()