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...
by Jonathan Halder | Apr 15, 2024 | MS Access, MS Access Forms, MS Access Queries, MS Access VBA Coding
Occasionally, I run into an issue where I am using some function within a BeforeUpdate event in an Access form which goes and updates the table with a SQL statement or query. This can produce some unwanted and messages about someone else editing the record and do you...
by Jonathan Halder | Apr 9, 2024 | MS Access, MS Access Forms, MS Access Queries, MS Access VBA Coding
I have been working on updating code for a customer form with a list box control storing a long list of files in various folders. There are filters on this form that can limit the files available to choose from. During my coding I noticed some performance problems....
by Jonathan Halder | Mar 27, 2024 | MS Access, MS Access Queries, MS Access VBA Coding
Me: Write a humorous limerick about ChatGPT failing to do what is expected. ChatGPT: There once was a bot named ChatGPT, Whose answers could often betray. Asked for a rhyme, it stuttered in time, And left folks in quite the disarray. It pondered and whirred with great...
by Jonathan Halder | Mar 26, 2024 | MS Access, MS Access Queries, MS Access VBA Coding
Today I worked on optimizing a query for a client. it wasn’t super long, about 2 seconds, but that was enough to make a noticeable delay for the users running the database. I wanted to make it a little snappier. It ended up boiling down to one thing, but first I...
by Jonathan Halder | Dec 18, 2023 | MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding
Refactoring code is something I do often. Trying to find ways to make things simpler and more readable are two reasons of many that I do this. As I work on code and refactor it, I find myself continually, daily, using tools to find and replace code, and not quite as...
