Category Name |
Brief Description |
Code, Functions & Utilities |
Are You Sure ? - A message box prompt |
Code, Functions & Utilities |
Calculate League - ranking by a given field |
Code, Functions & Utilities |
Cnull - Replaces nulls with Zeros |
Code, Functions & Utilities |
Cnull for strings, returns a string or "" |
Code, Functions & Utilities |
Coding to Import files |
Code, Functions & Utilities |
Compares 2 similar databases and allows differences to be identified |
Code, Functions & Utilities |
Constants for everyday database use |
Code, Functions & Utilities |
Flash a Window (API Call) |
Code, Functions & Utilities |
Inserts spaces after each character or number |
Code, Functions & Utilities |
Is the character Alphabetical ? |
Code, Functions & Utilities |
MonthText - Returns the name of a month |
Code, Functions & Utilities |
Number Suffixes (Nst, Nth, Nrd) |
Code, Functions & Utilities |
Open/Save File Dialog Box (API Call and Structure) |
Code, Functions & Utilities |
Proper - Capitalises the first letter of each new word |
Code, Functions & Utilities |
Remove spaces from a string |
Code, Functions & Utilities |
Returns a number as text |
Code, Functions & Utilities |
Right justify a string. |
Code, Functions & Utilities |
Wait until a shell has finished (Article ID: Q99940) |
Databases |
Can't remember what you just called that query you created ? |
Databases |
Database that encrypts and decrypts text when supplied with a password |
Databases |
Function that returns whether it is Jet 2.0 or Jet 2.5 running |
Databases |
MS Access 2.0 Easter Egg! |
Databases |
Opened Exclusively ? |
Databases |
UK Phoneday Convertor |
Forms |
Form Captions and Titles - Set across the database |
Forms |
Help Tips - Description code |
Forms |
Improved Text Box Controls |
Forms |
Timer example on a form |
How Do they Do That? |
FTP using Access |
Macros |
Defines Macro warnings |
Macros |
Menu bar for forms - Reduced Instructions |
Macros |
Standard Autoexec macro |
Main Processes |
Progress Meter for lengthy Main Processes |
Main Processes |
Rival Main Progress Meter |
Networks |
Connecting/Disconnecting to Drive D (Client Access) |
Networks |
Retrieve the network username of a user |
Queries |
Counts the number of records in a query |
Queries |
Replacing openquerydef from MS Access 1.X |
Reports |
Printing text direct to printer (Article ID: Q105662) |
Reports |
Report switch board that easily prints or previews reports. |
Tables and Data |
Attach all flat files in a database into MS Access |
Tables and Data |
Clear_Table - Removes all entries from a table |
Tables and Data |
Create a table to import data into |
Tables and Data |
Importing a set of Excel spreadsheets into the database |
Tables and Data |
Is the Table/Recordset Empty ? - Returns TRUE if it does |
Tables and Data |
Month table - maps months, quarters, calendar month and month text |
Tables and Data |
Save Record Command |
Tables and Data |
Store field names and field descriptions in a table |
User Inferface |
DIY Msgbox, set your own options instead of YES, NO, CANCEL etc ? |
User Inferface |
Enable/Disable Menu items API (Article ID Q88940) |
User Inferface |
Routines to Handle Import Error tables |
User Inferface |
Show Database Name (Article ID: Q98681) |
User Inferface |
Tool Tips (Article ID: Q119991) |
User Inferface |
Two Listbox Item selector just like the wizards use |