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

User experience and checkbox labels

by Jonathan Halder | Jul 19, 2024 | MS Access, MS Access Features, MS Access Forms

I had a customer who was confused as to why a checkbox was being checked or unchecked at seemingly random times. In this particular case, the checkbox label was very wide and butted right up to the button to save the data on the form and close it. In Access, when you...

Deftype statements in VBA – What?

by Jonathan Halder | Jul 16, 2024 | MS Access, MS Access Features, MS Access VBA Coding

I had never heard of this keyword. I was perusing the Microsoft Learn web site and happened across this in the VBA reference here: Deftype statements (VBA) | Microsoft Learn Here is the basic definition from that page: Used at the module level to set the default data...

Finding the width of arbitrary text in Access VBA

by Jonathan Halder | Jul 11, 2024 | MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access VBA Coding

I’m revisiting my ListBox control work from these two articles: Access ListBox Row Source and Type | Access JumpStart ListBox Column size adjustments | Access JumpStart The second article discsusses how to adjust column sizes using the ColumnWidths property and...

Access Query to Excel Data table, quick!

by Jonathan Halder | Jul 8, 2024 | MS Access, MS Access Features, MS Access Queries

Sometimes my customers ask me for data from their database that they want to see in a way they’ve never looked at or needed to look at it before. When this happens to me and the answer is a data pull, I will often either pull up an existing query with the answer...

Adding a deployment script to an existing Access JumpStart app (Part 6)

by Jonathan Halder | Jun 5, 2024 | MS Access, MS Access Features, MS Access VBA Coding

I wrote a script to deploy my Microsoft Access application which utilizes my company’s Access JumpStart framework which is available for purchase from our store. In the previous parts I’ve explained how I’ve done the first 6 steps of my script: Step 1 – Update the...

Access and ODBC: a quick overview

by Jonathan Halder | May 17, 2024 | MS Access, MS Access Features, MS Access Queries

One great thing about Access is all the various ways it can connect to data in tables. Using ODBC, Access can connect to anything with an ODBC driver that you can install. I’ve done connections using datasource names as well as DSN-less connections to SQL...
« 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.