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...
by Jonathan Halder | Aug 5, 2024 | Blogging
This is one reason why I don’t like giving time estimates to customers. You know the drill: Customer: So how long is it going to take you to do X? Me: Uh, when do you want it? Customer: Yesterday. Me: Not that fast… how about on Friday? My decision for...
by Jonathan Halder | Aug 1, 2024 | MS Access, Versioning
I use an SVN server to store versioning information for all my Access work that I do. A shout out to the OASISsvn Access Add In and TortoiseSVN for Windows which are two pieces of software I use daily in my Access versioning work. How it saved by butt today: I had a...
