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...
by Jonathan Halder | Jul 11, 2024 | MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access VBA Coding
I’m revisiting my ListBox control work from these two articles: Access ListBox Row Source and Type | Access JumpStart ListBox Column size adjustments | Access JumpStart The second article discsusses how to adjust column sizes using the ColumnWidths property and...
