Access JumpStart
  • Homepage
  • Blog
Select Page
  • Homepage
  • Blog

Using a Null Object pattern in VBA Polymorphic classes

by Jonathan Halder | May 1, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding

If you have an interface class object and you implement several types of the object, what can you do when your object has no handler? That’s where the Null Object pattern comes into play. Here’s an example of how you could implement the Null Object Design...

Access DevCon 9 (2025) Day 1 my reaction

by Jonathan Halder | Apr 10, 2025 | Blogging, MS Access, MS Access Features

Day 1 Agenda: 1Access Community UpdateKarl Donaubauer2Programming Modern ChartsColin Riddington3Microsoft Graph APIMaria Barnes4VBE_ExtrasJohn Mallinson5News from the Access TeamMicrosoft Session 1 was a little scary, Frankly, Microsoft does not seem to want Access to...

From Errors to Solutions: Implementing Transactions in Complex Database Imports

by Jonathan Halder | Apr 9, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access VBA Coding

Today I started working through using a transaction to cover another complex series of database transactions. One of my customers was receiving an error message that a record was already deleted during an import. In this case, the import process takes a while and if...

Upgrading our AJS template

by Jonathan Halder | Apr 2, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding, Versioning

In today’s adventure, I have a complex application I am updating from an older version of our Access Jump Start application template from when we were calling it RDF (Rapid Development Framework). I am doing this so I will have access to some of the newer...

Dragging and dropping between Access Files

by Jonathan Halder | Mar 27, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding

Did you know that you can drag and drop items from the navigation pane in one Access database to another Access database? I used this feature today as I needed to copy a somewhat complex form to display a series of entries in a linked table in both databases filtered...

Ahh! Egg on my Face! (Or: Input mask and value options)

by Jonathan Halder | Mar 25, 2025 | MS Access, MS Access Features, MS Access Forms

So I was wrong yesterday about phone number input masks and input values. An input mask value specifies a format, whether the mask is stored in the value, and the placeholder for users to enter data into the mask. This Microsoft web site discusses the pros and cons of...
« Older Entries

Get a Daily Email

An email loaded with my tips and musings.

    We won't send you spam. Unsubscribe at any time.

    Recent Posts

    • The HCI Way™ – A Dive into Agile Project Management and Sales!
    • Why I think hourly billing is nuts
    • A day in the life
    • Working in small chunks – deliver faster
    • Checking open forms and shutting down Access from code

    Recent Comments

    1. RichardRost on Why I think hourly billing is nuts
    2. Using combo boxes to select an entry and update form fields | Access JumpStart on Hiding duplicate records using running totals over a group
    3. | Access JumpStart on Super Simple Code Kata
    4. Mike Wolfe on Running parallel SQL server databases for testing
    5. Custom Tags For Custom tags for form controls – reimagined code | Access JumpStart on Custom tags for form controls – the case to use them for

    Archives

    • May 2025
    • April 2025
    • March 2025
    • February 2025
    • January 2025
    • December 2024
    • November 2024
    • October 2024
    • September 2024
    • August 2024
    • July 2024
    • June 2024
    • May 2024
    • April 2024
    • March 2024
    • February 2024
    • January 2024
    • December 2023
    • November 2023
    • December 2022
    • March 2022
    • January 2022
    • June 2021
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020

    Categories

    • Blogging
    • MS Access
    • MS Access Features
    • MS Access Forms
    • MS Access Queries
    • MS Access Reports
    • MS Access Tables
    • MS Access VBA Coding
    • TDD
    • Uncategorized
    • Versioning
    Copyright © Halder Consulting Inc.