Site Map

Home
About Us
FAQ
Cookie Policy
Applications
DEMO Versions
Application Utilities
Program Updates
Access Add-Ins
Purchase Software
Downloads
Database Services
Example Databases
Code Samples
Security Challenges
Access/Windows Blog
Bugs and Fixes
Access Europe User Group
News and Events
Videos
Useful Links
Testimonials
Contact

Main Sections

Database Analyzer & Viewer Pro
Table Analyzer & Viewer Pro
UK Postal Address Finder
JSON Analyse & Transform
School Data Analyser
School Payments System
SDA Link
Curriculum Enrichment Organiser
Exam Timer

Database Analysis Tools
Translation Tools
DEMO Versions
Application Utilities
Application Help Files

Applications

Access Add-Ins

Access Application Translator
Access Studio
Access/Windows/Office Version Check
Available Connections
JET ShowPlan Manager
Navigation Pane Helper
SQL to/from VBA Converter
Standard Module Object Generation

32 to 64-bit Conversion
32 to 64-bit: Conditional Compilation
32 to 64-bit: Manage Procedures
32 to 64-bit: My Future Plans
32 to 64-bit: Variables & Type Statements
A Trip Down Memory Lane
Access Security- MDB/MDE vs ACCDB/ACCDE
Access Specifications Issues
Access Wizards, User Data & Cache
Accurately Move Forms & Controls
Add / Remove Line Numbers in Code Modules
AI: Using ChatGPT to write code
Annotate Google Maps in Access
Application Parts & Templates
Attachment Field Issues
Automatic Form Resizing Tutorial
Big Forms and Reports for Modern Monitors
Centre Form On Screen
Compare Control Help Text Methods
Complex Datatypes in Access
Copy Text From Anywhere On Screen Using OCR
Create JSON Files from Access
Debunking Myths about the Autoexec Macro
Dock Forms to the Access Window
Gradient Background Fill on Forms
How Access Stores Queries
How Access Templates Are Made
Improve Security in Access Databases
Installing Multiple Office Versions
Is Location Trusted . . . and does it matter?
Issues Modifying Split Forms
Issues with lookup fields in Tables
Modern Chart Improvements
Monaco SQL Editor
Multivalued Fields...& why you shouldn't use them
New Style Message Box: Part 1 - Using Wizhook
New Style Message Box: Part 2 - Using Eval
Purpose of System Tables
Filtering with Contains gives inconsistent results
Query Join Types
Recover Deleted Database Objects
Relationships and Referential Integrity
Remove deleted objects from MSysObjects table
Running Access on a Tablet PC
Securing Your Data - Encrypted Split No Strings DB
Security Alerts in the Message Bar
Set Default Control Properties in Forms & Reports
Show Plan – Run Faster
Sort Bit Fields in Linked SQL Server Tables
Sort Value Lists
Speed Comparison Tests
Synchronise Data
The WizHook Object - Hidden & Undocumented
Timer Comparison Tests
Use Column History in Memo fields
Use Name AutoCorrect Successfully
Using the new VBA Project Signing feature
Write Conflict Errors
Zooming Feature Is Now Available

Access Articles

Example Databases

Add a Countdown to a Timeout Message Box
Add a Timeout to Message Boxes
Add colour to queries, listboxes & combos
Add References using code
Age Calculations
Align Text With Spacers
Always Open Popup Forms in Specified Location
Application.UserControl Property
Autofit or Zoom? Match Text to Form Control
Calculate Distance Between Locations
Case Sensitive Password Validation
Change Office Language Using Code
Change Query Views Using Command Bars Code
Change Resolution Using Code
Check if an Application is Running
Check Internet Connection Using Code
Check Procedure Exists
Clear the Immediate Window using Code
Close all VBE windows
Colour Conversion Code
Compile Modules using code
Copy Meetings & Appointments in Outlook
Count Jobs in Print Queue
Create ACCDB & ACCDE Files using code
Create Index on SQL View
Database Object Types & Collections
Database Statistics
Detailed System Info
Disable Design View In ACCDB Files
Disable Shortcut Menus in Reports
Easter calculator
Edit Linked Excel data in Access
Encoded Map Path Co-ordinates
Fast File Copy using a Windows API
Fill down in tables, queries, forms
Fix Google maps in Access web browser control
Fix Filtered Scrollbar Issue
Fix Shrunken Navigation Pane
Forcibly Shutdown Access
Formatted Message Box
Get Computer Name
Get Control Positions & Sizes Using Code
Get Control Properties Using Code
Get Default Printer
Get list of VBA references & locations
Get Network Path
Get Office License Info Using Code
Get Office/Windows Language Info Using APIs
Get Office/Windows Language Info Using Code
Get User Full Name
Get User Name
Get Value in Previous Record
Get full list of VBA references & locations
Hide Access Splash Screen
Hide or Move the Quick Access Toolbar using code
Is Form Loaded?
Is Form Open as a Subform?
Is My Database Compiled?
Is Report Open as a Subreport?
Linked No Tables
List Access Error Codes
List All Installed Apps
List All Module Procedures
List Environ Variables
List Tables with Complex Fields
Manage Taskbar/Navigation Pane/Ribbon
Manage Totals row using VBA
Masked Input Box
Maximize Restored Form After Making Visible
Message Box Constants & Values
Missing Trigonometric Functions
Module Type property
Move Option Group Controls Using Code
Negative Total Pages On Report
New Style Access Message Boxes With Timeout
On/Off Toggle Slider Control
Open Database with Shift Bypass using Code
Paint Me Transparent in a Continuous Form
Personalised Popup Forms (Win 10 / 11)
Progress Bar
Prevent Copy & Paste in Form
Prevent Opening Objects From the Navigation Pane
Rank order in queries
Remove core Windows modern apps using Power Shell
Report Group Pages
Reset the Property Sheet
Restart Current Database Using Code
Restore Missing Status Bar
Save As Text / Load From Text
Select All Text in a Textbox
Set the Application Icon Using Code
Set Character Limit In Long Text Fields
Set Default Printer
Show Color Dialog
Show Font Dialog
System Date Time Check
Unicode Input Box
Update All Form & Report Fonts
Upend Query
View Form Code

Code Samples

Access Bug Summary - Sept 2026
Access Bug Summary - Aug 2026
Access / Office Bug Summary - July 2026
Access / Office Bug Summary - June 2026
Access / Office Bug Summary - May 2026
Access / Office Bug Summary - Apr 2026
Access / Office Bug Summary - Mar 2026
Access / Office Bug Summary - Feb 2026
Access / Office Bug Summary - Jan 2026
Access Bug / Issues Summary - Dec 2025
Access Bug / Issues Summary - Nov 2025
Access Bug / Issues Summary - Oct 2025
Access Bug Summary - Sept 2025
Access Bug Summary - July/Aug 2025
Black Border Bug
BUG: Callback function crashes Access
BUG: Popup forms with breakpoints & navigation
BUG: Query Designer Insert/Delete Columns
BUG: Version 2408 and Hanging Access Tasks
Datasheet Totals Row Bug
Disabled Datasheet Fields Undone By Events!
Disappearing button images & captions (FIXED)
Export Objects to HTML Encoding Issues
FIXED: Error 3283 - refreshing links using code
FIXED: Error 3611 - refreshing links using code
Lookup Wizard Bug (FIXED)
Module type code fails from library database
Tables Disappear In Relationships Window
Two Font Display Bugs in Version 2309

Bugs and Fixes

Access/Windows Blog

A Masterclass in Access Security
ACCDB to MDB Conversion Issues
Access Command Line Switches
Access DevCon presentations - Apr 2025
Access File Limits
Access Infographics
Access Issues Fixed
Access Keyboard Shortcuts
Access News VIDEO - AEK Conference (Oct 23)
Access Roadmap Update (Oct 2022)
Access Roadmap Updated (Apr 2025)
Add Style to Windows, Forms and Message Boxes Attached, associated, detached . . .
Breakpoints and special keys
Cascading Combo boxes and listboxes
CCP or not CCP? That is the Question!
Change the Font Size in the Property Sheet
Changes to Access Roadmap
Click Me And I Disappear
Code Signing VBA Projects with Timestamp
Command Line Project Signing
Copy Message Box Text to Clipboard
Create Messages using the Expression Service
Customize The Access Message Box
Dates in Excel and Access
Dictation in Access
Disable Design View Shortcuts
Drag & Drop Database Objects
Enrol for Windows 10 Extended Security Updates
Epson announces end of laser printers
ERROR: Trust Center Settings in ACCDR files
Export Customised Ribbon
Fix Blocked Office Updates
Fix Context Menu Errors
Fix Navigation Bar Half Height problem
Form Datasheet ribbon missing in popup form
Form Page Headers & Footers
Full Screen Mode in Access
Happy Birthday. Access Is 30!
Hide the Application Interface with No Code
In Praise Of SysCmd(555)
Install Windows on iPhone
Introducing the NENAPUTS query
Isla - R.I.P.
Issues with Boolean Variables and Fields
Large Address Awareness in 32-bit Access
Linked table passwords exposed
Load Local Files Faster in Edge Browser Control
Localization Issues in Access
Locked and disabled control puzzle
Making Automatic Form Resizing work for you
Manage Old Data: Archive, Mark or Delete?
Manage Windows Smart Screen Warnings
Maximum Password Length in Access Files
Maximum Width of Access Forms & Reports
Navigation pane search bar code
NEW - Create SQL Query Menu Item
New features in the VBE_Extras add-in
Notepad++ Updates Compromised
Now you CAN open more tables and databases
Office & VBE Menu Languages Different
Oops-how did that make an ACCDE file?
Open Queries Directly in SQL View
Outlook: Check your Connection
PUZZLE: Access Message Boxes with no code
RegExp Added to VBA Library with Version 2508
Reserved Errors - no message for this error
Roadmap Updated (May 2026) - 3 New Features
Safe Mode VBE en Francais
Select All Data in a Form
Size Limits on Access Code Modules
Size To Fit Form
Small Change in Sharepoint - Not Many Affected?
Strikethrough Font in Access
Suggested Improvements to IMEX Data Tasks
Summary of New And Upcoming Features
Switchboard Manager in modern Access versions
SysCmd Actions (Documented & Undocumented)
Tab Control Page Caption Alignment Issue
Teaching Callouts in Office Apps
Teams Integration Causing Office Problems
The Curious Case of the Multi Row Tab Control
The Development of an Icon!
The Power of Data
The Strange Dotted Square 'Bug'
Two New Access Features - Autumn 2024
Two New Access Features in the Beta Channel
Unblock downloaded files - remove MOTW
Unsplit Database Tables
Use Multiple Tags on Form Controls
Using the Scroll Lock Key in Excel
Using the Zooming Feature Effectively
VBE Option Statements
What's Up with Aptos?
Why are the Min, Max and X buttons disabled?
Why Can't I Create an ACCDE file?
Why does SSMA fail to import my tables?
Why Isladogs? Why Access?
Why Rushmore?
Windowed & Non-Windowed Controls in Access
You Can REALLY Do All That With Forms?

Access Europe User Group

32 to 64-bit Conversion
A Baker's Dozen of Tips, Tricks & Tools
Access Studio
Advanced Data Grid Integrated with Access
Advanced Interactive Gantt Charts
Annotating Google Maps in Access
Automate DSN-Less Connections to SQL Server
Better Access Charts - The Next Generation
Building Ribbon Interfaces in Code
Cataloguing & searching emails
Classic vs Modern Charts
Command Bars & the Access Shortcut Tool
Create Applications in Blazor
Custom Ribbons Using Command Bars
Creating calendar format reports
Database Analyzer and other tools
Developing COM Add-Ins for Microsoft Access
Drag and drop: behind the scenes
Faking Non-Normal UIs with Normal Data
Features of MZ-Tools to improve productivity
GraphAuthenticator - 'New' Outlook solved!
High impact - Custom dialogs & notifications
Image / Photo Cataloguer in Access
IMEX Data Tasks / Extended File Properties
Improved, Enhanced Message Box
Inaugural Meeting
Interactive Gantt Chart Scheduler
New and Forthcoming Features in Access
Northwind 2.0-Inventory/String Functions
Optimising Queries & the JET ShowPlan
Optimizing Queries in SQL Server
Orchestrate Access with Multi-App Automation
PowerApps for Access Developers
Spot the Difference – new style Access MsgBox
Sprinkle a little UI Magic on your Access apps
SQL Server Tips & Tricks for Access Developers
Standard Module Object Generation
State-of-the-art Access charts with charts.js
Streamline Import Specs with VBA Classes
Streamline Form Code using Class Modules
The Future of Access
UI Tips/Tricks and New Access Features
Update, update . . . the company is in a state!
Use AI to Create Open Template Scaffolds
Use AI for Test Driven Development in Access
Use SQL Geography data in Access
Use the Edge browser control to extend Access
Using AI Assistants with Access
Using ADO Recordsets in Access
Using Class Modules in the Real World
Using Grid Lanes in Access
Using Power Automate with Office Apps
Using Treeviews with Access Applications
Using Twilio for texting from Access
Using VBA to create a class based on a table
Using VBE_Extras add-in with Access
Using vbWatchdog with Access
Version Control for the Sole Developer
Working with the Windows API

Show/Hide Tables
Hidden Message
Activation
Encrypted Split No Strings
Complex Deep Hide Attachment Mystery

Security Challenges

UK Postal Address Finder
JSON Analyse & Transform
School Data Analyser
School Payments System
SDA Link
Curriculum Enrichment Organiser

Program Updates

Database Consultancy
Database Conversion
Database Repairs
Database Security

Database Services

YouTube Videos

Videos

Currency Exchange Rate Tracker
Student ICT Database
Table Analyzer & Viewer
Translate & Speak
UK Postal Address Lookup

Application Source Code

Return to Top