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 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)...
