by Jonathan Halder | Aug 12, 2024 | MS Access, MS Access Features, MS Access Forms, MS Access VBA Coding
I watched half of a new Access Users Group video on the tree view control by Pete Poppe which I link to at the bottom of this message. I learned something new. The last time I used the Treeview control I never ended up implementing it in a customer’s project...
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 | 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 23, 2024 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access VBA Coding
If you are using DoEvents in your VBA code to allow form updates or preventing Windows from labeling your Access app as Unresponsive, make sure you consider the potential ramifications. DoEvents not only chimes in to the OS that it’s awake, but it also allows...
by Jonathan Halder | Jul 19, 2024 | MS Access, MS Access Features, MS Access Forms
I had a customer who was confused as to why a checkbox was being checked or unchecked at seemingly random times. In this particular case, the checkbox label was very wide and butted right up to the button to save the data on the form and close it. In Access, when you...
