Commands

Public Sub AppVer()

Prints the App Version Info (Prop_AppStdVerInfo) to the immediate window

Public Sub BumpAppFrontEndVer(Optional AddNum As Integer = 1, Optional TurnOffAllSubdatasheets As Boolean = False)

Increases the application front end minor version in preparation for a release.

Public Sub cc()

Open the Control Centre form

Public Sub DebugEnable(Optional val As Boolean = True)

Set the global xf_DebugEnabled variable

Public Property Get FrameworkIsVisible() As Boolean

Return a boolean indicating whether the framework objects are visible or not.

Public Sub FrameworkRemove(RemoveTables As Boolean)

Remove the Extension Framework from the database

Public Sub FrameworkShow(show As Boolean)

Show or hide all the objects associated with the Extension Framework apart from 'xf_BaseInstance'.
Hiding the framework objects declutters the database object list and visually simulates the framework being part of the Access system.
Module 'xf_BaseInstance' remains as an indicator that xf is present.

Public Sub FrameworkUpdateMasterPassword()

Update the master password, validating the old password first. The password is stored in the local framework settings table.

Public Function FrameworkValidateMasterPassword() As Boolean

Validate the Extension Framework master password. Used when accessing the Control Centre or other sensitive screens. This is intended to be low security - just enough to block a curious user. As long as code is not locked (ie. in an MDE), it can easily be worked around.

Public Sub FwkVer()

Prints the Framework Version Info (Prop_FrameworkCodeDescription) to the immediate window

Public Sub ShadowTableRefresh(TableName As String)

Refresh the shadow tables for the named table

Public Sub ShadowTablesRefresh()

Refresh all the shadow tables in the database, using the 'IsShadowTable' field in the linker 'database tables' table to identify the tables to be shadowed

Public Sub Table_AutonumberFix(TableName As String)

Fix the autonumber column 'next value' if it has become set to an out of sequence number by the linked tables autonumber bug.
Generates a dummy insert in order to set the value back to MAX(Autoumber).

Public Sub Tables_RelinkAll()

Relink all the tables in the database

Public Sub Tables_RemoveAllLinked()

Remove the 'dbo' prefix from all table defs (this is automatically added when adding SQL Server linked tables)

Public Sub Tables_RemoveDboPrefixFromAll()