Routines extracted from the library and packaged up as the CodeScan db ...


Module: Utilities - Case adjustment (appr 200 lines)
Proper, ProperForm
	Objective: Capitalise the first letter of each word in a string.
		  Principally for use in the context of Names and Addresses
		  Little bit less 'dumb' than most case adjusters.
		  Potentially interfaces to a Menu so it may be turned on/off.
	ProperForm is a wrapper around Proper
	ProperForm is intended for use directly from the AfterUpdate
	event of a text field.

Module: Utilities - Document Tables (appr 440 lines)
DBM_Document_Tables
	Objective: Create a table containing the schema definitions fro a db
		  Optionally, produce a report.
		  Optionally, skip various sections Table Properties, Indexes, Relationships.

Module: Utilities - Search and Replace (appr 1100 lines)
QuoteProtect, SQL_QuoteProtect
	Objective: Very simple routines to eliminate the 'quote hassle' when using string expressions
		  ... real time and temper savers
		  e.g. Me.txtPlaceName.DefaultValue = "=" & QuoteProtect$(strInitialValue)
		  or    varResult = DLookup("[Field7]","tblSample","[Address 1]=" & SQL_QuoteProtect$(strCurrAddr))

String_In_Forms_Find, String_In_Forms_Alter
	Objective: Scan through (optionally) all properties of (optionally) all forms to locate and display
		 (and/or optionally log) the occurrence of a search string.
		 The 'Alter' variant will replace the search string with another.
		 A further option allows the replacement to be suppressed if the search string occurrence
		 is within a larger exclusion string. e.g. a match on Smith will be bypassed if the actual hit
		 is on the excluded string Smithson
String_In_Reports_Find, String_In_Reports_Alter
	Objective: Very similar task for Reports

String_In_Queries_Find, String_In_Queries_Alter
	Objective: Logically similar, but with adifferent implementation ...
		  Creates a query showing all of the queries that contain the search string, and where each 
		  occurrence is placed.
