by Jonathan Halder | Aug 11, 2024 | Blogging
In the consideration of charging customers for custom software you are writing for them there are different terms here that sometimes get used interchangeably. I’m going to define them for this article as two very distinct and separate things and will do so in...
by Jonathan Halder | Aug 9, 2024 | MS Access, MS Access VBA Coding
The resounding answer to this is “Yes”. BUT – what if you can’t seem to make it work? There are actually a number of ways to monetize your Access skills: Offering your services as an Access Application developer to create, modify, and/or...
by Jonathan Halder | Aug 8, 2024 | MS Access, MS Access Forms, MS Access VBA Coding
I was working with a friend yesterday and he was showing me how he was showing a bound dropdown list on a combo box on a bound form. He was using a UNION query and VBA to update the combo box RowSource value each time to include another row in the dropdown if the...
by Jonathan Halder | Aug 7, 2024 | MS Access, MS Access VBA Coding
Don’t get me wrong. Access VBA can perform very well in most situations. There have been a few times where I’ve needed to improve the speed of some function I was using and Access just took too long. One of those is hashing values for files. There is a...
by Jonathan Halder | Aug 6, 2024 | MS Access, MS Access Features, MS Access Queries, MS Access VBA Coding
Access Error (3155) ODBC: “Query timeout expired”. It happened when trying to insert a new record into a linked table called “order” I’m using ODBC driver 17 in this case and it happened twice. Not sure if the user tried to do it twice or...