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 12, 2024 | MS Access, MS Access VBA Coding
I came across this fantastic code on DevHut by Daniel Pineault. I was doing file hashing and found Daniel’s script here: Get a File Hash using VBA | DEVelopers HUT (devhut.net) This in turn uses the PS_GetOutput script he explains here: VBA – Run...
by Jonathan Halder | Apr 10, 2024 | MS Access, MS Access VBA Coding
What is polymorphism? It’s a concept in object oriented programming that allows you to define different versions of objects that all share some of the same characteristics. In language, an example would be two different cars. A Lamborghini is a car, as is a...
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 | Apr 8, 2024 | MS Access, MS Access Forms, MS Access VBA Coding
The other day I was coding an Access Form which displays a file list to choose files to import into the database. I had created the following components: An Access Form named: ImportForm A Class Module to handle a full list of files available for importing and...
