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

Scrambling data to share a database

by Jonathan Halder | Oct 4, 2024 | Blogging, MS Access, MS Access Queries, MS Access Tables, MS Access VBA Coding

The Access 97 database I was trying to get working on my 365 Access was written to scramble data in existing tables in a destructive way so that users of a forum or other developers could look at code without seeing sensitive data. I copied some large tables I had...

Access VBA Sometimes Fails Silently

by Jonathan Halder | Sep 23, 2024 | MS Access, MS Access Queries, MS Access VBA Coding

I’m working in Access today and I noticed that a confirmation dialog box I have set up to ask me as a developer if I really want to send an email was not working. Initially I thought it was because of a flag that was failing to get set, but that wasn’t it....

The Joys of Combo Dropdown Group Headers

by Jonathan Halder | Sep 12, 2024 | MS Access, MS Access Forms, MS Access Queries

What? Combo dropdown group headers? What voodoo is this? I have a combo box on a continuous form in an Item Description field. Each row on the continuous form can contain a line item that can be populated from different sources. There is a job estimate source where...

Access Object Names With Spaces and NiceDLookup

by Jonathan Halder | Sep 5, 2024 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access Tables, MS Access VBA Coding

So first things first.  It is not recommended that you use spaces or special characters in your table names as it can cause problems referencing them or cases that are ambiguous and may cause unintended results in the code. But maybe you have used them in the...

Access Primer for Businesses – way more than a database

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

There are of course a multitude of uses for a relational database system. Remember that although natively Access defaults to storing data relationally in tables using the file based ACE system (Access Connectivity Engine), it can really use any ODBC or OLE DB...

Troubleshooting an ODBC error in Access

by Jonathan Halder | Aug 6, 2024 | MS Access, MS Access Features, MS Access Queries, MS Access VBA Coding

Access Error (3155) ODBC: “Query timeout expired”. It happened when trying to insert a new record into a linked table called “order” I’m using ODBC driver 17 in this case and it happened twice. Not sure if the user tried to do it twice or...
« 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

    • Dealing with complex SQL queries
    • Guiding principles
    • Copying and modifying code / forms / objects
    • Two Form Filtering strategies
    • Poking around to find new customers

    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.