Government Funded IT, Computing, Telecommunications courses Southwark

...those encountered in a business database application; focusing in particular on triggering VBA from objects such as queries and forms. PREREQUISITES...

...those encountered in a business database application; focusing in particular on triggering VBA from objects such as queries and forms. PREREQUISITES...

...the macro results Understanding Code Formatting (Indents, etc) Reading from and writing to a cell Absolute vs Relative Referencing Playing back VBA Stepping...

...left, right, mid, instr) Working out what kind of value is residing in a cell (isnumeric, isstring, isdate... etc) Creating your own Functions A value...

...Using the status bar as a Progress Indicator Password protecting your VBA code Creating a Toolbar Manually Adding in useful built-in buttons Adding buttons...

...emails per region Word Creating a memo with a chart Access Attaching to a database and appending the spreadsheet data Codesigning your...

...Fields Field Switches DOCUMENT TEMPLATES Introduction Creating and Using Templates FORM FIELDS Introduction Creating an on-line form Creating a form...

...Structures Looping Control Structures Performing Multiple Actions on an Object Non-Structured Statements Sub Procedures CONTROLS, DIALOG BOXES AND USER-DEFINED...