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

Access Programming – What I do and Why (Find and Replace)

by Jonathan Halder | Dec 18, 2023 | MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding

Refactoring code is something I do often. Trying to find ways to make things simpler and more readable are two reasons of many that I do this. As I work on code and refactor it, I find myself continually, daily, using tools to find and replace code, and not quite as...

Access Programming – What I do and Why (source control part 4)

by Jonathan Halder | Dec 6, 2023 | MS Access, MS Access Queries, MS Access Tables, MS Access VBA Coding

I’ve been discussing how I use version control in 3 previous emails / articles which you can find here: Access Programming – What I do and Why (source control) | Access JumpStart Access Programming – What I do and Why (source control part 2) | Access JumpStart Access...
MS Access Runtime Error (2176): “The setting for this property is too long.”

MS Access Runtime Error (2176): “The setting for this property is too long.”

by Jonathan Halder | Mar 7, 2022 | MS Access Forms, MS Access Queries

This error occurs because, drum-roll please…. The setting for this property is too long. So in this particular case, the developer was trying to create a long SQL string using multiple UNIONs with a complex query and trying to set this string to the RowSource...
Gotcha! You thought you deleted a subform record but…

Gotcha! You thought you deleted a subform record but…

by Jonathan Halder | Jun 18, 2021 | MS Access, MS Access Forms, MS Access Queries

I recently experienced a frustrating issue that had me scratching my head for a while. I had a PO form with a Line Item subform and I could edit lines and when I tried to delete a line it was removed from the subform. BUT… If I closed and reopened the same PO...
When entering an order query for how much inventory is available

When entering an order query for how much inventory is available

by Jonathan Halder | Sep 11, 2020 | MS Access Queries

Presented with the problem: You have a stock of inventory of items you are renting. You know how many you have purchased.  You have what customers have ordered for particular dates. You want to know while entering an order, how many items are available for a...
Nested Data Relationships Tutorial

Nested Data Relationships Tutorial

by Jonathan Halder | Jun 19, 2020 | MS Access Queries, MS Access Tables

A common database issue in the world is the need to store lists of related items.  This might be a Bill of Material (or BOM) for a business application to describe all the parts and assemblies needed to ship a particular product, or it might be something like meal...
« 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

    • Poking around to find new customers
    • Setting up an automated Access App upgrade strategy
    • Sometimes one makes dumb mistakes :P
    • Form filtering using unbound text boxes continued
    • Basic Filtering with form text boxes

    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.