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

Squashing the error 3167 “This record has been deleted” bug

by Jonathan Halder | Apr 14, 2025 | Blogging, MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding

Today’s adventure was to fix a bug in a menu form in which the user was getting a “This record has been deleted” error message. What was happening was that the navigation form was based on a local temp table that gets rebuilt whenever the application...

Access DevCon 9 (2025) Day 2 my reaction

by Jonathan Halder | Apr 11, 2025 | Blogging, MS Access, MS Access VBA Coding, Versioning

SessionTitlePresenter6Proven Sales StrategiesJuan Soto7The Battle of the VCS Add-InsPhilipp Stiefel, Adam Waller8Power Automate with VBAYnte Jan Kuindersma9twinBASIC+AI in Access DevelopmentMike Wolfe10Access Tools for DevelopersColin Riddington Session 6 was a very...

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...

Polymorphism in Action: Refactoring File Processing Routines in Access

by Jonathan Halder | Apr 8, 2025 | Blogging, MS Access, MS Access VBA Coding

Today’s Access adventure involved refactoring code as an evolution from getting a particular set of line item records associated with a file to be processed when that file was selected from another form. In the first iteration of the code for testing, I was...
« Older Entries
Next 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

    • Copying and modifying code / forms / objects
    • Two Form Filtering strategies
    • Poking around to find new customers
    • Setting up an automated Access App upgrade strategy
    • Sometimes one makes dumb mistakes :P

    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

    • June 2025
    • 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.