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

TransferSpreadsheet Not Cutting It? I Use This VBA Routine Instead

by Jonathan Halder | Aug 27, 2025 | Blogging, MS Access, MS Access Queries, MS Access Tables, MS Access VBA Coding

A few years ago I wrote a routine to copy an Access query or table to a block of Excel cells because I was having issues with DoCmd.TransferSpreadsheet not being able to always do what I needed. I found that copying the entire recordset to an array variable and then...

Access Tip: How to Break into Your Code at Exactly the Right Moment

by Jonathan Halder | Aug 22, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding

Today I was debugging Access and was working in some complex code that iterated over a large number of records. I wanted to stop at a particular record and run through it step by step. The record could be identified by using the RS variable which represented a DAO...

TDD in Access: Separating Logic from Forms for Cleaner Tests

by Jonathan Halder | Aug 21, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD

I decided to do some tests today, but didn’t even get to writing any yet. The issue was that I had a function tied to a button click event event inside a form which referenced various controls on the form. Normally, it’s easy to refactor this by simply...

Access Date Filtering: Between vs. >= and < Explained

by Jonathan Halder | Aug 19, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access VBA Coding

When you need to specify date ranges in Access, remember the following helpful tips: By default, a date includes the time of midnight 00:00:00. So #1/1/2025# is equivalent to the expression #1/1/2025 00:00:00# or #1/1/2025 12:00:00 AM#. When you use Between, it always...

What Happens When You Press Ctrl-A in an Access Text Box?

by Jonathan Halder | Aug 18, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access VBA Coding

Do you know what happens if you are in an Access text box and press Ctrl-A? You might expect all the text in it to be selected like a text box on a web page or in a Word document. But it doesn’t. If you are in a text box on a form in the normal single form view...

Adventures in AI: My Quest for Smarter Development Tools

by Jonathan Halder | Aug 14, 2025 | Blogging, MS Access, MS Access VBA Coding, TDD

Today I spent the time I would have taken to write an article to start reviewing the 8th light’s TDD starter’s guide: https://8thlight.com/insights/getting-started-tdd-practical-guide I’m excited to practice more TDD. But the lion’s share of...
« Older 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

    • TransferSpreadsheet Not Cutting It? I Use This VBA Routine Instead
    • Avoiding Exclusive Access in Access: My Strategy for Seamless Updates
    • Access Tip: How to Break into Your Code at Exactly the Right Moment
    • TDD in Access: Separating Logic from Forms for Cleaner Tests
    • Access Date Filtering: Between vs. >= and < Explained

    Recent Comments

    1. Colin Riddington on What Happens When You Press Ctrl-A in an Access Text Box?
    2. Jonathan Halder on What Happens When You Press Ctrl-A in an Access Text Box?
    3. Colin Riddington on What Happens When You Press Ctrl-A in an Access Text Box?
    4. Colin Riddington on What Happens When You Press Ctrl-A in an Access Text Box?
    5. Jonathan Halder on Access Report Trick: How to Tell If You’re Running as a Subreport

    Archives

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