Access JumpStart
  • Homepage
  • Email Archive
Select Page

Logic errors – the ugly step cousin of compilation and run time errors

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

Today’s work was to fix logic errors in my application. The problem is that overlapping data in files that normally deletes the older data and replaces it with the newer data is replacing all the older data even though it is earlier than what appears in the...

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.