Data Dictionary
|
Insert these components into your Access MDB, or use the
supplied MDB stand-alone to get a selectable, formatted report of the tables, fields,
indexes and relationships in your system. |
DataDic.zip (52K) |
Help via Word
|
Ever wanted a help file that doubles as a printable user guide
and is in a form which the users can maintain themselves? This snippet shows you how you
can set up a Microsoft Word document to be your context-sensitive help system. |
WordHelp.zip (22K) |
WordPro To Word
|
A simple Access routine to automate the conversion of Lotus
WordPro documents to MS Word |
Pro2Word.zip (24K) |
Proper Case
|
A function to convert strings to 'proper' case, i.e.
capitalising the first letter of each word. Handles hyphenated names and 'mc' names. |
ProperCase.zip (19K) |
Parse
|
A function to parse strings using any delimiter, building an
array of the separate elements. |
Parse.zip (19K) |
AutoCounter
|
A routine to generate an ascending sequential number in a
query so that the output is labelled 1->n. For example showing Sales Order lines from 1
upwards. |
AutoCounter.zip (27K) AutoCounter2K.zip (24K) |
Timer
|
A very simple function to build into your testing to calculate
the elapsed time taken by any process. Call once to start the timer and again to stop it
and get the result. |
Timer.zip (15K) |
