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 | Jul 30, 2024 | MS Access, MS Access Features, MS Access Forms, MS Access VBA Coding
Yesterday, I was talking about the BeforeUpdate form event and BeforeUpdate Access control event as ways I was looking at triggering a validation function and then canceling the event so the update would not occur. A reader wrote in to mention usage of the Change...
by Jonathan Halder | Jul 29, 2024 | MS Access, MS Access Forms, MS Access VBA Coding
It’s easy to get burned when trying to set up custom validations for Access fields and enforcing them while the form is being filled out. I have a form with the following fields (of the type): Vendor Name (string) Is Vendor Active (checkbox) Is On PO form...
by Jonathan Halder | Jul 26, 2024 | MS Access, MS Access VBA Coding
Sometimes you can get runtime errors when you are trying to assign the value of a control to some VBA object. For example, consider this statement: TempVars!NewTempVar = Form_orders.order_id What we are trying to do is set the NewTempVar in the TempVars system...
