Access Consultant UK
MS Access & Excel Developer
Design and support for your Access, Excel, Office and networking requirements
MS Access / VBA
- Access QueryDefs Mis-save Subquery SQL
- Extracting/Updating SQL from a QueryDef
- ANSI Standards in String Comparisons
- Combining Rows-Opposite of Union
- Debugging in VBA
- Example Filtering on a Form
- Finding Jet SQL Help
- Front-End / Back-End (FE/BE)
- Function to Move (Forwards or Backwards) Through Weekdays
- Reposition a Field Within a Table
- Literal DateTimes and Their Delimiters (#)
- Producing a List from Multiple Records
- Quotes (') and Double-Quotes (") - Where and When to use them
- Referring to Items on a Sub-Form
- Require Variable Declaration
- ShellWait() Function
- SQL JOINs
- Subqueries in SQL
- Using "&" and "+" in WHERE Clause
- Class Module to Handle Opening Forms Hierarchically
- SELECT Record From Group With Max Value
- Cascading Forms
- Code Signing
- Excel Functions in Access
- Why Values in Unbound Form Controls do not Persist
- Invoking a Database From the Command Line
- Memo Field Angst
- How to Debug SQL String
- Relinking Tables using VBA
- How to Stop Bound Forms from Updating Automatically
- Export Multiple Worksheets into Same Workbook
- Cascaded Form Filtering
- Progress Indicator in Access
- Time Interval Overlapping (MS Access 2003)
- Context-Sensitive Help
- Aggregate Query Woes
- Handling Optional Parameters in VBA
- Database Properties
- Email Command to Remote User
- Referencing Controls on a Form (Dot v Bang)
MS Excel / VBA
- Starting with Excel VBA Code
- Excel Module (Code) Names
- Using VLookUp in Excel to Link to Excel 'Tables'
General Topics