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

MS Office Dev Team is not perfect and neither are we!

by Jonathan Halder | Oct 23, 2024 | Blogging, MS Access, MS Access Features

Had an interesting little bug in Office today in which a solid 2px black (#000000) border does not appear around a subform control (and this ends up applying to many other controls and shapes as well) I was really scratching my head, until I went online to find out if...

When to use Macros vs VBA in Microsoft Access

by Jonathan Halder | Sep 18, 2024 | MS Access, MS Access Features, MS Access VBA Coding

As an Access developer, my typical knee jerk response to Macros is: DON’T USE MACROS, anything a macro can do, VBA can do! However, there are a couple of things macros can be used for that VBA actually can’t do. — GASP —  WHAT??? One thing...

Transparent = True or Visible = False?

by Jonathan Halder | Sep 16, 2024 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Reports, MS Access VBA Coding

They sound the same, don’t they? But they aren’t!!! Often you want to control elements visibility on forms.  For example, you might want to hide certain fields or buttons from view when you are adding a record instead of editing it. In a recent case for my...

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

When to use Access, Excel, or both!

by Jonathan Halder | Aug 28, 2024 | Blogging, MS Access, MS Access Features

This article from Microsoft Support discusses the differences between using Microsoft Access and Excel for managing data, helping users decide which tool is best suited for their needs. I’ve used Copilot to help me create a quick summary of the article you can...

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

    • Working in an Agile way…
    • Manual test driven development
    • Dealing with complex SQL queries
    • Guiding principles
    • Copying and modifying code / forms / objects

    Recent Comments

    1. Neil Sargent on Two Form Filtering strategies
    2. RichardRost on Why I think hourly billing is nuts
    3. Using combo boxes to select an entry and update form fields | Access JumpStart on Hiding duplicate records using running totals over a group
    4. | Access JumpStart on Super Simple Code Kata
    5. Mike Wolfe on Running parallel SQL server databases for testing

    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.