| Setting | Value |
|---|---|
| Application name: | MDB Doc |
| Is it compiled? | False |
| Does it have a broken reference? | False |
| Name | Type | Value |
|---|---|---|
| Name | Memo | C:\Users\john2\Documents\Work\MDBDoc\mdbdoc165\mdbdoc.mda |
| Connect | Memo | |
| Transactions | Yes/No | True |
| Updatable | Yes/No | True |
| CollatingOrder | Long Integer | 1033 |
| QueryTimeout | Long Integer | 60 |
| Version | Memo | 4.0 |
| RecordsAffected | Single | 0 |
| ReplicaID | GUID | |
| DesignMasterID | GUID | |
| Connection | Empty | |
| AccessVersion | String | 08.50 |
| Build | Single | 467 |
| AppTitle | String | MDB Doc |
| StartUpShowDBWindow | Yes/No | True |
| StartUpShowStatusBar | Yes/No | True |
| AllowShortcutMenus | Yes/No | True |
| AllowFullMenus | Yes/No | True |
| AllowBuiltInToolbars | Yes/No | True |
| AllowToolbarChanges | Yes/No | True |
| AllowBreakIntoCode | Yes/No | True |
| AllowSpecialKeys | Yes/No | True |
| Show Values Limit | Single | 1000 |
| Show Values in Indexed | Single | 1 |
| Show Values in Non-Indexed | Single | 1 |
| Show Values in Remote | Single | 0 |
| Track Name AutoCorrect Info | Single | 0 |
| Perform Name AutoCorrect | Single | 0 |
| CpgConversion | Single | 1252 |
| ProjVer | Long Integer | 140 |
| Auto Compact | Single | 0 |
| Show Values in Snapshot | Single | 1 |
| Show Values in Server | Single | 0 |
| Use Default Page Folder | Single | 0 |
| Use Default Connection File | Single | 0 |
| Row Limit | Single | 10000 |
| ANSI Query Mode | Single | 0 |
| UseAppIconForFrmRpt | Yes/No | False |
| NavPane Closed | Single | 0 |
| NavPane Width | Single | 215 |
| NavPane Category | Single | 0 |
| NavPane View By | Single | 0 |
| NavPane Sort By | Single | 1 |
| Show Navigation Pane Search Bar | Single | 0 |
Click here to return to the contents list
MDB Doc is configured to not display USys tables
Click here to return to the contents list
There are no queries in this database.
Click here to return to the contents list
| Name | Created | Last Updated | Has Module | Record Source | Description |
|---|---|---|---|---|---|
| frmMdbdocStartup | 30/06/2001 18:48:34 | 24/10/2003 20:47:50 | True | frmMdbdocStartup description | |
| frmPreferences | 09/12/2003 21:11:32 | 20/10/2007 20:29:16 | True | USysMDBDocPreferences | Form for amending preferences |
Click here to return to the contents list
There are no reports in this database.
Click here to return to the contents list
| Name | Created | Last Updated | Type | No. Lines | Description |
|---|---|---|---|---|---|
| mdbdclsFileHandle | 08/07/2001 20:46:20 | 25/10/2003 14:36:06 | Class Module | 122 | Class module encapsulating file I/O routines |
| modDocumenter | 08/07/2001 20:46:12 | 28/07/2001 14:54:30 | Normal Module | 1788 | Functions pertaining to documenting various aspects of the database. |
| modGlobalConstants | 15/10/2007 20:00:48 | 20/10/2007 20:39:56 | Normal Module | 50 | Constant values used throughout the code cross modules. |
| modPreferences | 10/12/2003 16:11:50 | 20/10/2007 20:39:33 | Normal Module | 127 | Routines related to user preferences. |
| modRegistry | 13/10/2007 14:27:50 | 13/10/2007 18:36:30 | Normal Module | 23 | Module including Registry handling code routines |
Click here to return to the contents list
| Prototype | No. Lines | Description |
|---|---|---|
| Public Property Get Filename() As String | 2 | Filename Get property - retrieves "Filename" property. |
| Public Property Let Filename(fname As String) | 2 | Filename Let property - allows it to be set. |
| Public Property Get FileMode() As String | 2 | FileMode Get property - allows it to be retrived |
| Private Property Get Filenumber() As Integer | 2 | FileNumber property - allows it to be retrieved. |
| Private Property Let Filenumber(num As Integer) | 2 | FileNumber property - allows it to be set. |
| Public Property Let FileMode(mode As String) | 4 | FileMode property - allows it to be set. Includes basic validation. |
| Public Function OpenFile() | 12 | Function to open file. |
| Public Function WriteData(data As String) | 6 | Function to write data to the file. Includes validation to stop it being written to a closed file, or one opened for read only access. |
| Public Function ReadData() As String | 8 | Function to read data from a file and return it. |
| Public Function CloseFile() | 3 | Function to close a file. |
| Private Sub Class_Initialize() | 3 | Initialise feature for the class - will set things up as class is initialised. |
| Public Function IsOpen() As Boolean | 2 | Function to determine if a file is open or not. |
| Private Sub Class_Terminate() | 2 | Function to tidy up on closing down the class. |
| Public Function AtEOF() As Boolean | 2 | Function to determine if the file is at the end of the file. |
| Prototype | No. Lines | Description |
|---|---|---|
| Public Function mdbdProcessDatabase(strFilename As String) As Boolean | 885 | Function that does the bulk of the processing. |
| Private Function mdbdGetPropertyType(prp As DAO.Property) As String | 48 | Returns descriptive property type given supplied property. |
| Private Function mdbdGetFieldType(fld As DAO.Field, intSize As Integer) As String | 67 | Returns descriptive field type from supplied field. |
| Private Function mdbdGetQueryType(qry As DAO.QueryDef) As String | 43 | Returns descriptive query type. |
| Private Function mdbdGetTableType(tdf As DAO.TableDef) As String | 38 | Returns descriptive table type. |
| Private Function mdbdGetRelType(rel As DAO.Relation) As String | 29 | Returns descriptive relationship type. |
| Private Function mdbdIsPK(tdf As DAO.TableDef, fld As DAO.Field) As Boolean | 23 | Returns True/False depending whether a specific field is part of a specific tables primary key. |
| Private Function mdbdGetDescription(obj As Object) As String | 13 | Returns the Description property of an object. |
| Public Function StartMDBDoc() As Boolean | 12 | Function called from Addins menu to start MDB Doc running. |
| Private Function mdbdListCodeBlocks(mdl As Module, outfile As mdbdclsFileHandle) As String | 142 | Provides a list of code blocks within a module and writes them to an output file. |
| Private Sub mdbdCloseObjects() | 26 | This sub closes any open objects prior to running |
| Public Function mdbdReplace2(Expression As String, Find As String, Replace As String, Optional Start As Long = 1) As String | 36 | Replace2 function taken from Tek-Tips database used for search/replace of special characters with their escape sequences. |
| Public Function mdbdReplaceSpecialChars(strInputString As String) As String | 19 | This function replaces special punctuation characters with their HTML escape equivalent |
| Private Function LoadStylesheets(clsfh As mdbdclsFileHandle, strHaltOnError As String) As Integer | 61 | This function loads the stylesheet specified in the preferences and writes the meta tag in the header. |
| Public Function StartLocalPreferences() As Boolean | 11 | Function called from Addins menu to start MDB Doc running. |
| Private Function GetGuidDescription(strGuid As String, strMajorVersion As String, strMinorVersion As String) As String | 16 | This function returns the string description of a specific GUID and version number. |
| Public Function FormatSQL(strSQL As String, blnNewlinePerField As Boolean) As String | 144 | SQL Formatting function for Access VBA, J Barnett, Oct 2007. |
| Private Function LoadRibbons(clsfh As mdbdclsFileHandle, strHaltOnError As String) As Integer | 66 | |
| Public Function PrepareSavefile() | 24 | Function to prepare the common dialog in Save file mode. Used by the button on the startup form. |
| Private Function getIndexFields(indx As DAO.Index) | 9 | Function to retrieve string list of fields in an index |
| Prototype | No. Lines | Description |
|---|---|---|
| Public Function mdbdGetPreference(strPreferenceName As String) As String | 37 | This function will retrieve the specified local preference from the preferences table. If there isn't one, it will retrieve it from the global prefs table. |
| Public Function mdbdLoadPreferences() As Integer | 53 | This function will retrieve the preferences from the preferences table and load them into an array. |
| Prototype | No. Lines | Description |
|---|---|---|
| Public Function RegKeyRead(i_RegKey As String) As String | 14 | Retrieve registry key value from WMI on current computer (the . in the GetObject call) |
Click here to return to the contents list
| Prototype | No. Lines | Description |
|---|---|---|
| Private Sub cmdAbout_Click() | 6 | Event Handler for About Button on the Startup form. |
| Private Sub cmdCancel_Click() | 2 | Event handler for Cancel button on MBD Doc startup form. |
| Private Sub cmdProcess_Click() | 26 | Event handler for Process button on MBD Doc startup form. |
| Private Sub cmdSelect_Click() | 7 | Event handler for "Select File" button on MBD Doc startup form. |
| Private Sub Form_Open(Cancel As Integer) | 29 | Form Open event - sets up form with default output location and checks that database is not in MDE format. |
| Private Sub txtOutputFile_AfterUpdate() | 6 | Checks to disable the "Process" button if the txtOutputfile text box is empty. |
| Private Function mdbdIsMDE(db As DAO.Database) As Boolean | 19 | Function to determine if a particular database is in MDE format or not. |
| Private Sub cmdPreferences_Click() | 13 | Sub to open the preferences form. |
| Private Function SetOutputFilename() As String | 47 | Function to generate the default output filename, based on the database name and the user preferences. |
| Prototype | No. Lines | Description |
|---|---|---|
| Private Sub cmdClose_Click() | 2 | Close button event handler |
| Private Sub Form_BeforeUpdate(Cancel As Integer) | 11 | Preferences screen updates to check whether current item contains contains a null (or not) value. |
| Private Sub Form_Close() | 5 | Form close event handler - it forces reloading of the preference data on form closing |
| Private Sub Form_Current() | 6 | Form current record event handler, making preference value read only (or not) depending on CanOverride preference. |
| Private Sub Form_Load() | 5 | Form Load event handler - sets form caption and title lable. |
Click here to return to the contents list
There are no report modules in this database.
Click here to return to the contents list
There are no macros in this database.
Click here to return to the contents list
There are no relationships in this database.
Click here to return to the contents list
Please note that MDB Doc only displays information about custom command bars.
There are no custom command bars in this database.
Click here to return to the contents list
There are no Data Access Pages in this database.
Click here to return to the contents list
| Name | Full Path | Reference Broken |
|---|---|---|
| Visual Basic For Applications | C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLL | False |
| Microsoft Access 15.0 Object Library | C:\Program Files (x86)\Microsoft Office\Office15\MSACC.OLB | False |
| Microsoft Office 15.0 Object Library | C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE15\MSO.DLL | False |
| OLE Automation | C:\Windows\SysWOW64\stdole2.tlb | False |
| Microsoft DAO 3.6 Object Library | C:\Program Files (x86)\Common Files\Microsoft Shared\DAO\dao360.dll | False |
| Microsoft Visual Basic for Applications Extensibility 5.3 | C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB | False |
Click here to return to the contents list
There are no ribbons in this database
Click here to return to the contents list
There are no Import/Export Specifications in this database.