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 18, 2024 | MS Access, MS Access VBA Coding
I recently needed to calculate the period number of a current date for a client. The current period is not exactly the current week number, it’s a specific week, but it could start on any particular day and end on any particular day. In my case, they specify it...
by Jonathan Halder | Jul 16, 2024 | MS Access, MS Access Features, MS Access VBA Coding
I had never heard of this keyword. I was perusing the Microsoft Learn web site and happened across this in the VBA reference here: Deftype statements (VBA) | Microsoft Learn Here is the basic definition from that page: Used at the module level to set the default data...
by Jonathan Halder | Jul 12, 2024 | MS Access, MS Access VBA Coding
A lot of Access users (especially newer ones) like to use the function DLookup to quickly lookup a value from a table or query. It is quite handy shorthand and can be used in VBA and in queries. The usage of DLookup is: DLookup (Expr, Domain, Criteria)...
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...
by Jonathan Halder | Jul 9, 2024 | MS Access, MS Access Forms, MS Access VBA Coding
In a previous article, I discussed a listbox conundrum I had with really long lists: Access ListBox Row Source and Type | Access JumpStart One of the things I wanted to do with this listbox was adjust the column sizes of the list on the fly, depending on the size of...
