Number Data Types Access data Types. Naming conventions The standard 'Reddick VBA Naming convention' for Access. Database Design Designing tables and columns to meet 1st, 2nd and 3rd normal form. NULL values Dealing with NULL values. Embed a Subquery Select As SubQuery Upsizing Upsize an Access database to SQL Server ODBC connections Create an ODBC connection to SQL Server
Defaults How to set form default properties. Filter as You Type Instantly filter a continuous form. Error traps Error trapping ODBC errors Form References Reference the controls on other forms or subforms. Replace Font Globally replace a Font in design view - this can fix bitmap vs ClearType font issues. Window Style Overlapping vs Tabbed Windows.
Colors Access color codes. Functions Access functions in SQL or VBA. Bulk Edit Loop through the controls on every form to change properties in bulk. VBA Keyboard shortcuts DAO and ADO Database Access via VBA
Error trapping NULLs You tried to assign the null value to a variable Invalid Procedure Call or Argument Decompiling and fixing VBA references. Progress Meter Display progress on the Status bar. Ribbon (toolbar) Maximise, Minimise or Hide the RIbbon Toolbar. Trusted Locations Set trusted network folders.
See also: Links to Microsoft Access books / Websites