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...
by Jonathan Halder | Aug 26, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access Tables, MS Access VBA Coding
Today I had a request from a customer with a database used for What If scenarios to allow him to do either do updates from the main tables consistently or to boot all other users out of their front ends so that he can do an update when one is required. The system is...
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...
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...
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...
