AEU28: IMEX Data Tasks/Extended File Properties
Lock Down Database Objects
Office & VBE Menu Languages Different
Access/Windows/Office365 Version Check Add-In
Gradient Background Fill in Forms
You Can REALLY Do All That With Forms?
AEU27: Use VBA to create a class based on a table
Change Query Views Using Command Bars Code
Datasheet Row/Column Select & Spell Check
AEU26: Command Bars & the Access Shortcut Tool
Highlight Control/Column in Continuous Forms
Rounded Corners in Forms
View/Edit IMEX Data Task Specifications
Click Me And I Disappear!
AEU28: View & Edit IMEX Data Task Specifications
AEU27: Use VBA to create a class based on a table
Protect Data in Tables and Queries
You Can REALLY Do All That With Forms?
Highlight Entire Form (Dim Background)
Access Wizards, User Data & Cache
Freeze Columns in Continuous Forms - Part 3
Move/Resize Borderless Form Using Mouse - Part 2
FIXED: Error 3283 when refreshing links
Hide & Restore Selected Columns - Part 2
Export Customised Ribbon
Paint Me Transparent in a Continuous Form
Move Borderless Form Using Mouse Event - Part 1
AEU25: Better Access Charts - The Next Generation
AEU26: Command Bars & the Access Shortcut Tool
Form Datasheet ribbon missing in popup form
AEU29: An Improved, Enhanced Message Box
Move/Resize Columns in Continuous Forms - Part 2
Move/Resize Columns in Continuous Forms - Part 1
Get Current Geolocation
Fix Issues with Hidden Duplicates in Reports
BUG: Query Designer Insert/Delete Columns
Reset the Property Sheet
Edit Data in Hidden Duplicates Forms - Part 2
Freeze Columns in Continuous Forms - Part 2
Freeze Columns in Continuous Forms - Part 1
Access News & Events
AEU24: Top 10 Advanced Features of MZ-Tools
Add Colour to Tab Control Pages
Hide Selected Columns in Continuous Forms - Part 1
Hide Duplicates in Continuous Forms - Part 1
View Database Objects & Metadata
Strikethrough Font in Access
Run External Apps from Access
Set BackColor of all Forms
Sort Columns in Continuous Forms
Highlight Control/Column in Continuous Forms
Copy Meetings & Appointments in Outlook
Highlight Filtered Columns in Continuous Forms
Restore Missing Status Bar
Database Services
Streamline Multiselect Filters in Continuous Forms
Database Consultancy
Get Control Positions & Sizes Using Code
Multiselect Filter in a Continuous Form
AEU23: Streamline Form Module Code
CDO EMail Tester
Database Repairs
Database Security
Database Conversion
Multiple Group & Filter
Open New Form & Close Original Form
Get Control Properties Using Code
Calculate Distance Between Locations
Extended File Properties
Filter By Form
Reserved Errors - no message for this error
32 to 64-bit: My Future Plans
Exam Timer
AEU22: Streamline Import Specs with VBA Classes
FIXED: Error 3611 when refreshing links using code
32 to 64-bit: Manage Procedures
Open Queries Directly in SQL View
32 to 64-bit: Variables & Type Statements
Suggested Improvements to IMEX Data Tasks
Security Alerts in the Message Bar
View/Edit IMEX Data Task Specifications
Office & VBE Menu Languages Different
Set Default Printer
Locked and disabled control puzzle - Pg 2 - SOLVED
Locked and disabled control puzzle - Pg 1
Long Value Binary fields in System Tables
Large Address Awareness in 32-bit Access
VBE Option Statements
Gradient Background Fill in Forms
32 to 64-bit: Conditional Compilation
Manage Label Printing
Highlight Search Results
Dictation in Access
Highlight Required Fields
Highlight Current Control in Single Forms
32 to 64-bit Conversion
UK Postal Address Lookup
Highlight Current Record in Continuous Form
Prevent Opening Objects From the Navigation Pane
Manage the Shift Bypass Property - Pg 3
Access News VIDEO - AEK Conference (Oct 2023)
Open Encrypted Database with Shift Bypass - Pg 2
AEU21: Use SQL Geography data in Access
Open Database with Shift Bypass using Code - Pg 1
Manage Totals row using VBA
Two Font Display Bugs in Version 2309 - FIXED
Linked table passwords exposed
Auto position objects in extended Access interface
Extend Access across Multiple Monitors
Synchronise Subform Scrolling
Accurately Move Forms & Controls
AEU20: The Future of Access
Access File Limits
Access News & Events
Useful Links
In Praise Of SysCmd(555)
Undocumented SysCmd Actions
AEU19: Database Analyzer and Other Tools
Database Analyzer Pro
Isla - R.I.P.
Translation Tools
Database Analysis Tools
The Strange Dotted Square 'Bug' FIXED
Using Combo Charts in Access
AEU18: Create Applications in Blazor
Change Query Views Using Command Bars Code
Count Jobs in Print Queue
Available Connections Add-In
Available Connections
Table Analyzer & Viewer Pro
AEU17: Interactive Gantt Chart Scheduler
Create ACCDB & ACCDE Files Using Code
Is a Report Open As a Subreport?
Is a Form Open As a Subform?
Is Location Trusted?
Centre Form On Screen
Module Type property
Now you CAN open more tables and databases
Age Calculation
Access Command Line Switches
Popup forms with breakpoints & navigation
AEU16: Northwind 2.0-Inventory/String Functions
Access User Groups: Europe (AEU)
Breakpoints and special keys
Tables Disappear In Relationships Window
Securing Your Database - A Tutorial
Maximum Password Length in Access Files
List All Module Procedures
Access Application Translator
Speed Test 2: CurrentDB/DBEngine(0)(0)/ThisDb
Automatic Form Resizing - Part 4
Making Automatic Form Resizing work for you
A Trip Down Memory Lane
Case Sensitive Password Validation
Password Login (with Session Login Information)
Unblock downloaded files by removing the MOTW
AEU15: Automate DSN-less Connections to SQL Server
The Curious Case of the Multi Row Tab Control
View Access Help
Using the new VBA Project Signing feature - Part 1
Adding Security to Access Databases - A Wish List
SQL to VBA & Back Again
Datasheet Totals Row Bug
BUG: Breakpoints and special keys
Navigation pane search bar code
AEU14: Creating calendar format reports
System Tray Alerts
ERROR: Trust Center Settings in ACCDR files
Progress Bar
Better Date Picker
Compare Control Help Text Methods
Table Analyzer & Viewer
Issues with Boolean Variables and Fields
The Horizontal Continuous Form
Use Name AutoCorrect Successfully
Build Your Own Simulated Split Form
The Emulated Split Form
Issues Modifying Split Forms
Set Default Control Properties in Forms & Reports
Automatic Form Resizing - Part 3
Automatic Form Resizing - Part 2
Automatic Form Resizing - Part 1
AEU13: Optimizing Queries in SQL Server
Use Multiple Tags on Form Controls
Access News & Events
Access Videos
Access Application Translator
Translate and Speak
BUG: Disabled Datasheet Fields Undone By Events!
Click Me And I Disappear
Maximum Width of Access Forms & Reports
Access Specifications Issues
Speed Test 7: Check Record Exists
AEU12: State-of-the-art charts in Access
Clear the Immediate Window using Code
Unicode Input Box
Formatted Message Box
Manage Windows Smart Screen Warnings
Maximum Password Length in Access Files
AI: Can ChatGPT be used to write malware?
Manage Old Data: Archive, Mark or Delete?
AI: Using ChatGPT to write code
Why Isladogs? Why Access?
Application Parts & Templates
AEU11: A Baker's Dozen of Tips, Tricks & Tools
Speed Test 15: Grouped Aggregate Queries
Speed Test 8: Optimising Queries
Speed Test 14: Loop vs Recursion
Automatic Form Resizing - Page 4
Automatic Form Resizing - Page 3
Automatic Form Resizing - Page 2
Automatic Form Resizing - Page 1
Why Rushmore?
Speed Test 10: Regex Or Not
Access/Windows/Office365 Version Check Add-In
Access/Office 365/Windows Version Check
Fixing the Navigation Bar Half Height problem
List Tables with Complex Fields
Speed Test 13: WHERE OR vs WHERE IN
Speed Test 12: Finding Unmatched Records
Unblock downloaded files by removing the MOTW
Using the new VBA Project Signing feature - Part 2
AEU10: Annotating Google Maps in Access
Annotate Google Maps in Access - Part 3
Annotate Google Maps in Access - Part 2
Annotate Google Maps in Access - Part 1
Epson announces end of laser printer production
Fix Google Maps in Access web browser control
Autofit or Zoom? Match Text to Form Control
Curriculum Enrichment Organiser
Message Box Constants & Values
The WizHook Object - Hidden & Undocumented
Align Text With Spacers
Access Keyboard Shortcuts
School Payments System
Exam Timer
Control the Application Interface
Attention Seeking Database
Access News & Events
Student ICT Database
SDA Link
The Power of Data
Hide Sensitive Data
CDO EMail Tester
View Access Help
AEU9: PowerApps for Access Developers
Happy Birthday. Access Is 30!
School Data Analyser
Access Add-Ins
Formatted Message Box
Complex Deep Hidden Attachment Mystery
Combo Box Auto Dropdown
Is Form Loaded?
Is Form Open as a Subform?
Access Error Codes
JET ShowPlan Manager Add-In
Available Connections Add-In
Greyed Out Controls : Disable or Lock?
Access Roadmap Update (Oct 2022)
Get Default Printer
AEU8: Cataloguing & searching emails
Is Location Trusted?
Update All Form & Report Fonts
Disable Design View In ACCDB Files
List All Installed Apps
Get Network Path
Change Resolution Using Code
Access News & Events
List Environ Variables
Check Internet Connection Using Code
JSON Analyse & Transform for Access
UK Postal Address Finder
Currency Exchange Rate Tracker
Add References using code
Compile Modules using code
Create ACCDB & ACCDE files using code
Introducing the NENAPUTS query
AEU7: Optimising Queries & the JET ShowPlan
Oops - how did that make an ACCDE file?
Why Can't I Create an ACCDE file?
Query Metadata Viewer
Hidden Message Challenge
AEU6: 32 to 64-bit Conversion (Peter Cole)
AEU5: Build Ribbon Interfaces in Code (Mike Wolfe)
AEU3: Classic vs Modern Charts (Crystal Long)
AEU1- Inaugural Meeting (Colin & Alessandro)
Access Europe User Group
Navigation Pane Helper Add-In
Navigation Pane Helper
How Access Stores Queries - Part 2
How Access Stores Queries - Part 1
Running Access on a Tablet PC
Limit the Number of Records
Using the Scroll Lock Key in Excel
Optimise Queries
ASCII Character Set
Control the Application Interface
Access Command Line Switches
Access Studio
Create Custom Splash Form
Standard Module Object Generation (SMOG)
Continuous subform scrollbar selection
Folder Image Viewer
Multivalued Fields...& why you shouldn't use them
Listbox Mouse Move Item Tooltips
Debunking Myths about the Autoexec Macro
Recover Deleted Database Objects
Access Issues Fixed
Changes to Access Roadmap
Drag & Drop Database Objects
Access Infographics
Install Windows 3.1 on an iPhone
Application Tips Example
A Better Date Picker
A Trip Down Memory Lane
Populate Junction Table
On/Off Toggle Slider Control
Fast File Copy using a Windows API
Encoded Map Path Co-ordinates
Missing Trigonometric Functions
Age Calculations
Use Column History in Memo Fields
Automatic Form Resizing
Set Character Limit In Long Text Fields
Speed Test 9: SELECT DISTINCT vs GROUP BY
Installing Multiple Office Versions
Adding Security to Access Databases - Wish List
View Form Code
Get User Full Name
Speed Test 11: $ Or No $
Rich Text Editor
Edit Linked Excel Data in Access
Hide Access Splash Screen
Return to Home Page Return to Top
UPDATED 2024-04-30
UPDATED 2024-04-28
UPDATED 2024-04-25
UPDATED 2024-04-24
UPDATED 2024-04-22
UPDATED 2024-04-21
UPDATED 2024-04-17
UPDATED 2024-04-09
NEW 2024-04-09
UPDATED 2024-04-08
UPDATED 2024-04-03
NEW 2024-04-02
UPDATED 2024-03-29
UPDATED 2024-03-29
NEW 2024-03-26
NEW 2024-03-26
NEW 2024-03-21
NEW 2024-03-19
NEW 2024-03-19
NEW 2024-03-16
UPDATED 2024-03-15
NEW 2024-03-14
UPDATED 2024-03-13
UPDATED 2024-03-11
NEW 2024-03-10
UPDATED 2024-03-10
NEW 2024-03-09
UPDATED 2024-03-08
NEW 2024-03-05
NEW 2024-03-02
NEW 2024-02-29
NEW 2024-02-29
NEW 2024-02-27
UPDATED 2024-02-27
NEW 2024-02-25
NEW 2024-02-24
UPDATED 2024-02-23
NEW 2024-02-22
NEW 2024-02-16
NEW 2024-02-14
UPDATED 2024-02-12
UPDATED 2024-02-09
NEW 2024-02-05
NEW 2024-02-04
NEW 2024-02-03
UPDATED 2024-02-02
NEW 2024-02-01
NEW 2024-02-01
NEW 2024-01-31
NEW 2024-01-30
NEW 2024-01-26
NEW 2024-01-26
NEW 2024-01-22
NEW 2024-01-21
NEW 2024-01-21
NEW 2024-01-16
NEW 2024-01-15
NEW 2024-01-14
UPDATED 2024-01-14
UPDATED 2024-01-12
UPDATED 2024-01-12
NEW 2024-01-12
NEW 2024-01-11
UPDATED 2024-01-10
UPDATED 2024-01-10
NEW 2024-01-07
NEW 2024-01-04
NEW 2024-01-01
UPDATED 2023-12-31
NEW 2023-12-30
UPDATED 2023-12-19
NEW 2023-12-16
UPDATED 2023-12-14
UPDATED 2023-12-13
UPDATED 2023-12-12
NEW 2023-12-10
UPDATED 2023-12-09
NEW 2023-12-07
NEW 2023-12-05
NEW 2023-12-05
UPDATED 2023-12-05
NEW 2023-12-04
NEW 2023-12-02
NEW 2023-12-01
NEW 2023-11-30
NEW 2023-11-27
NEW 2023-11-25
NEW 2023-11-24
NEW 2023-11-19
NEW 2023-11-17
NEW 2023-11-15
NEW 2023-11-14
NEW 2023-11-12
NEW 2023-11-10
NEW 2023-11-09
NEW 2023-11-07
UPDATED 2023-11-07
NEW 2023-11-05
NEW 2023-11-05
NEW 2023-11-04
NEW 2023-11-03
NEW 2023-11-03
UPDATED 2023-11-02
NEW 2023-11-01
NEW 2023-10-30
UPDATED 2023-10-28
NEW 2023-10-24
NEW 2023-10-23
UPDATED 2023-10-22
UPDATED 2023-10-19
UPDATED 2023-10-18
UPDATED 2023-10-10
NEW 2023-10-02
UPDATED 2023-09-26
UPDATED 2023-09-26
NEW 2023-09-24
NEW 2023-09-24
UPDATED 2023-09-10
UPDATED 2023-09-10
NEW 2023-09-09
NEW 2023-09-08
NEW 2023-09-02
UPDATED 2023-08-29
NEW 2023-08-03
UPDATED 2023-08-02
NEW 2023-07-31
UPDATED 2023-07-27
UPDATED 2023-07-26
UPDATED 2023-07-26
UPDATED 2023-07-21
UPDATED 2023-07-18
UPDATED 2023-07-18
NEW 2023-07-12
UPDATED 2023-07-11
UPDATED 2023-07-09
UPDATED 2023-07-08
NEW 2023-07-05
NEW 2023-07-04
UPDATED 2023-06-28
UPDATED 2023-06-24
UPDATED 2023-06-14
UPDATED 2023-06-14
UPDATED 2023-06-13
UPDATED 2023-06-13
UPDATED 2023-06-13
UPDATED 2023-06-08
UPDATED 2023-06-07
NEW 2023-06-06
UPDATED 2023-05-17
UPDATED 2023-05-10
UPDATED 2023-05-10
UPDATED 2023-05-10
UPDATED 2023-05-07
NEW 2023-05-07
UPDATED 2023-05-06
UPDATED 2023-05-05
NEW 2023-05-04
NEW 2023-05-04
UPDATED 2023-04-30
UPDATED 2023-04-30
UPDATED 2023-04-30
UPDATED 2023-04-14
NEW 2023-04-07
NEW 2023-04-06
NEW 2023-04-06
NEW 2023-04-05
UPDATED 2023-04-04
NEW 2023-04-02
UPDATED 2023-03-30
UPDATED 2023-03-27
UPDATED 2023-03-25
NEW 2023-03-18
NEW 2023-03-13
NEW 2023-03-13
NEW 2023-03-11
NEW 2023-03-08
UPDATED 2023-03-08
NEW 2023-03-07
UPDATED 2023-03-07
UPDATED 2023-03-03
UPDATED 2023-03-03
UPDATED 2023-03-03
NEW 2023-03-01
NEW 2023-02-28
UPDATED 2023-02-27
UPDATED 2023-02-26
UPDATED 2023-02-26
UPDATED 2023-02-26
NEW 2023-02-25
NEW 2023-02-24
UPDATED 2023-02-22
UPDATED 2023-02-22
UPDATED 2022-02-17
NEW 2023-02-04
NEW 2023-01-30
NEW 2023-01-29
UPDATED 2023-01-29
NEW 2023-01-28
NEW 2023-01-23
NEW 2023-01-18
NEW 2023-01-14
NEW 2023-01-13
NEW 2023-01-11
NEW 2023-01-08
NEW 2023-01-07
NEW 2023-01-03
UPDATED 2022-12-31
NEW 2022-12-29
NEW 2022-12-27
UPDATED 2022-12-27
UPDATED 2022-12-27
UPDATED 2022-12-27
NEW 2022-12-24
UPDATED 2022-12-24
UPDATED 2022-12-23
UPDATED 2022-12-23
UPDATED 2022-12-22
NEW 2022-12-21
NEW 2022-12-20
NEW 2022-12-15
NEW 2022-12-14
NEW 2022-12-14
NEW 2022-12-13
NEW 2022-12-06
NEW 2022-12-05
UPDATED 2022-12-01
NEW 2022-11-29
UPDATED 2022-11-29
UPDATED 2022-11-27
UPDATED 2022-11-26
NEW 2022-11-26
UPDATED 2022-11-25
NEW 2022-11-23
NEW 2022-11-22
UPDATED 2022-11-21
UPDATED 2022-11-21
UPDATED 2022-11-20
UPDATED 2022-11-20
UPDATED 2022-11-20
UPDATED 2022-11-20
UPDATED 2022-11-20
NEW 2022-11-18
NEW 2022-11-17
UPDATED 2022-11-14
UPDATED 2022-11-11
NEW 2022-11-10
NEW 2022-10-29
UPDATED 2022-10-29
UPDATED 2022-10-28
UPDATED 2022-10-28
UPDATED 2022-10-27
NEW 2022-10-24
NEW 2022-10-23
NEW 2022-10-23
UPDATED 2022-10-23
UPDATED 2022-10-20
NEW 2022-10-16
NEW 2022-10-14
NEW 2022-10-13
NEW 2022-10-12
NEW 2022-10-12
NEW 2022-10-11
NEW 2022-10-11
NEW 2022-10-07
NEW 2022-10-06
NEW 2022-10-05
NEW 2022-10-04
UPDATED 2022-10-03
NEW 2022-10-03
NEW 2022-10-02
UPDATED 2022-09-30
UPDATED 2022-09-26
UPDATED 2022-09-25
NEW 2022-09-25
NEW 2022-09-22
NEW 2022-09-22
NEW 2022-09-09
NEW 2022-09-08
NEW 2022-09-06
NEW 2022-09-04
NEW 2022-09-01
UPDATED 2022-08-24
NEW 2022-08-22
NEW 2022-08-22
NEW 2022-08-22
NEW 2022-08-22
NEW 2022-08-22
NEW 2022-08-21
NEW 2022-08-19
NEW 2022-08-08
UPDATED 2022-08-07
NEW 2022-07-30
NEW 2022-07-27
UPDATED 2022-07-25
UPDATED 2022-07-24
NEW 2022-07-23
UPDATED 2022-07-22
NEW 2022-07-19
NEW 2022-07-19
NEW 2022-07-18
NEW 2022-07-17
NEW 2022-07-17
UPDATED 2022-07-09
UPDATED 2022-07-08
NEW 2022-07-02
NEW 2022-06-29
NEW 2022-06-25
NEW 2022-06-28
NEW 2022-06-28
NEW 2022-06-28
NEW 2022-06-23
NEW 2022-06-23
NEW 2022-06-08
UPDATED 2022-06-08
UPDATED 2022-06-05
NEW 2022-05-28
NEW 2022-05-23
NEW 2022-05-22
NEW 2022-05-21
NEW 2022-05-20
UPDATED 2022-05-08
UPDATED 2022-04-06
UPDATED 2022-04-02
NEW 2022-03-26
UPDATED 2022-03-16
NEW 2022-03-13
NEW 2022-03-12
NEW 2022-03-11
NEW 2022-03-11
NEW 2022-03-06
NEW 2022-03-01
NEW 2022-02-26
NEW 2022-02-25