Access JumpStart
  • Homepage
  • Email Archive
Select Page

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 »

Recent Posts

  • Quoting Access projects
  • A few quick VBA tips for better development and deployment of your Access App
  • Reminder: You can’t link linked Access file tables
  • Sharing the load – an exercise in splitting Access Files
  • Simplifying Complex File Importing rules

Recent Comments

  1. Jonathan Halder on Reminder: You can’t link linked Access file tables
  2. Colin Riddington on Reminder: You can’t link linked Access file tables
  3. Text File Import / Export Recipe code part 3 (implementing iImportFile) | Access JumpStart on Text File Import / Export Recipe code part 2 (AppProcedures module)
  4. Text File Import / Export Recipe code part 2 (AppProcedures module) | Access JumpStart on Text File Import / Export Recipe code
  5. Text File Import / Export Recipe code | Access JumpStart on A Reusable Recipe for Importing and Exporting Text Files in Access

Archives

  • February 2026
  • January 2026
  • December 2025
  • November 2025
  • October 2025
  • September 2025
  • August 2025
  • July 2025
  • 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.