Microsoft Access Syntax

Tables and Columns

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.
Upsize an Access database to SQL Server

Form Design

Defaults - How to set form default properties.
Error trapping ODBC errors
Access 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.

VBA coding

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

Examples

Progress Meter - Display progress on the Status bar.
Error trapping NULLs - You tried to assign the null value to a variable
Microsoft Access front end launcher
Invalid Procedure Call or Argument - Decompiling and fixing VBA reference.
Ribbon (toolbar) - Maximise, Minimise or Hide the RIbbon Toolbar.
Trusted Locations - Set trusted network folders.




Copyright © SS64.com 1999-2018
Some rights reserved